Copy worksheets from one WB to another with external Macro

  • Thread starter Thread starter shabb090177
  • Start date Start date
S

shabb090177

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?
 
Presumably you also wan to copy the contents of A into B? In which case can
you not just save A as B ?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A solution to Excel2007 slowness when running Excel 2003 macros 1
File Could not be Found 1
Programming Logic 2
Copy worksheet 3
Activate "current workbook" 4
Macro for closing files only if they are open 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1

Back
Top