Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EZ - Pull data from another workbook
workbooks(OLD).sheets("sheetName").range("A1").cop y _
activeworkbook.sheets("otherSheet").range("A1") -- Tim Williams Palo Alto, CA "Brad" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I pull sum from one workbook into another? | Excel Discussion (Misc queries) | |||
pull excess of 65,500 into a workbook | Excel Discussion (Misc queries) | |||
Coding ? pull information from one Workbook to another | Excel Programming | |||
Using Vlookup to pull data from another workbook | Excel Programming | |||
Pull Data from a closed workbook, without opening it. | Excel Programming |