Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro question: how to copy information from another workbook.
Hi
I need some help with a macro. By today it looks like Sub Update_List Workbooks.Open FileName:="c:\data\List.xls" Sheets("ListNr1").Select Cells.Celect Selection.Copy Windows("Paul.xls").Activate Sheets("ListNr1").Select Cells.Select ActiveSheet.Paste End Sub I have made about 20 workbooks with 20 different names. Paul is one of them, and the macro above is stored in that workbook. I need a macro that always copy the information to the workbook where the macro is started. Instead of the line Windows("Paul.xls").Activate I can use ActiveWindows.ActivateNext but this will cause problem if more than one workbook is active by the time the macro is started. I would appreciate if someone could help me with this. Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy information from a row to another sheet in the workb | Excel Discussion (Misc queries) | |||
Copy and Paste information from woorksheet onto different workbook | Excel Discussion (Misc queries) | |||
Copy information from Excel to Word using 1 macro | Excel Discussion (Misc queries) | |||
How do I copy the information from one workbook to another? | Excel Discussion (Misc queries) | |||
Macro to insert new sheets and copy information. | Excel Programming |