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?

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?

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