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
|