View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 846
Default EZ - Pull data from another workbook

I have retrieved the name of another workbook with

OLD = ActiveWorkbook.Name

When I go back to the workbook I am actually running the Macro in, how do I
copy data from OLD to be able to paste into the active workbook? The answer
should be of this sort (which don't work):

Windows(OLD).Range("C5").Copy
Workbooks(OLD).Range("C5").Copy

TIA, Brad