Copy and Paste from a Closed Workbook

Hi,

I've recorded a macro to copy a range of cells (Q6:Q26) from a different open workbook ("Control Area Sheet Test.xls") and paste the values into a different cell range (T104:T124) in the workbook that I activated the macro in ("TBA TEAM LIST (3).xls").

Is it possible to have the module copy from 'Control Area Sheet Test.xls' without the file being open?
I've come across the 'GetValuesFromAClosedWorkbook' function, but I'm not sure how to use this to copy a cell range to the clipboard.

Any help would be most appriciated!

Please Login or Register  to view this content.