| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy worksheets from one WB to another with external Macro
Hi.
I have an external C.xls (in XLSTART folder) with a macro to run. When I open FileA.xls, I want to be able to copy all worksheets from FileA.xls to FileB.xls with the macro in FileC.xls. Any pointers? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy worksheets from one WB to another with external Macro
Presumably you also wan to copy the contents of A into B? In which case can
you not just save A as B ? -- Cheers Nigel "shabb090177" wrote in message ups.com... Hi. I have an external C.xls (in XLSTART folder) with a macro to run. When I open FileA.xls, I want to be able to copy all worksheets from FileA.xls to FileB.xls with the macro in FileC.xls. Any pointers? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy worksheets from one WB to another with external Macro
Well, the purpose of copying is to backup the original file (A). It
seems because the macro is external in C, it kept copying worksheets of C to B. Not A. Thanks in advance. Nigel wrote: Presumably you also wan to copy the contents of A into B? In which case can you not just save A as B ? -- Cheers Nigel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy & paste macro for multiple worksheets | Excel Discussion (Misc queries) | |||
| macro to copy into different worksheets | Excel Discussion (Misc queries) | |||
| Subject: Macro- Copy same rows into own worksheets | Excel Programming | |||
| Macro to Copy Worksheets | Excel Worksheet Functions | |||
| CREATE MACRO TO COPY MULTIPLE WORKSHEETS | Excel Discussion (Misc queries) | |||
Hybrid Mode
