MrExcel Publishing
Your One Stop for Excel Tips & Solutions

macro to copy workbook

Posted by bob on March 15, 2001 3:22 PM

I am trying to use a macro in template.xls to copy the download file book1 with 3 sheets to
template.xls instead of using links but the macro dosn't work all the time.
I was wondering if anyone knows a short form of global VBA for copying
workbooks and their sheets. I am using excel 2000.

Posted by Dave Hawley on March 15, 2001 10:17 PM


Bob, not sure I'm on track here, but have you tried:

ThisWorkbook.SaveCopyAs "C:\TEMP\Template.XLT"


ActiveWorkbook.SaveCopyAs "C:\TEMP\Template.XLT"


OzGrid Business Applications