Macro code for moving between files

I am trying to run a macro that will open a file from a folder and manipulate the file in various ways. Once complete it will do the same with the next file in the folder, etc. The manipulation includes copying from a source workbook that is already open (Dept macro 2014 Testing.xlsm in my example). The macro should copy data as well as an entire sheet from the source workbook.

I am challenged with the code to use for the workbook(s) opened when moving from window to window (source workbook to workbook opened from list). I am ok with the source workbook as I just use that workbooks name. I can't figure out out to reference the opened workbook(s).

Please Login or Register  to view this content.

I have made the line of the code where I need help with blue.


Thanks

Thanks wenqq3
I have yet to try it.
Started on another way to solve my issue and just working through those steps.
I will still try it though as I may apply this concept for other steps in my process.