| 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 | |||
Linear Mode
