Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy and paste between two workbooks
I have a macro that copies specific cells between workbooks, but I have
several workbooks I'd like to use it with (different company information) and each is named differently. Because the macro switches back and forth copying and pasting it names the Specific Workbook to copy from or paste to. Can I make it generic somehow so I can use the macro with any workbook without having to rename my workbooks and rename them again when the macro has finished running. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy and paste between two workbooks
use the ActiveWorkbook.Next application and erase all the workbook names in
your code (ex. workbook( "aaaaaaaa.xls")), when you run the macro start from the workbook you want to copy from an the macro will automatically switch to the next opened workbook and paste all what hes has previusly copied. HTH PD. Remember just to have tow workbooks opened "Paula" wrote: I have a macro that copies specific cells between workbooks, but I have several workbooks I'd like to use it with (different company information) and each is named differently. Because the macro switches back and forth copying and pasting it names the Specific Workbook to copy from or paste to. Can I make it generic somehow so I can use the macro with any workbook without having to rename my workbooks and rename them again when the macro has finished running. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy and paste between workbooks | Excel Discussion (Misc queries) | |||
Copy and paste - two workbooks | Excel Programming | |||
Copy and Paste Between Workbooks | Excel Programming | |||
macro to copy and paste between 2 workbooks | Excel Programming |