Excel VBA copy XL-2007 Macro-Enabled Workbook as excel-2003 file with no macros

Question

I''m looking for a vba macro that will make a copy of the current Excel 2007 macro-enabled workbook with the name I specify as an Excel 2003 macro-free document. It should also keep the current workbook open and in the Excel 2007 format (so save-as wouldn't work).

I can't figure out how to do the copy operation...

Answer 1

Maybe you can adapt this: http://exceltip.com/st/Delete_all_macros_in_a_workbook/document_using_VBA_in_Microsoft_Excel/505.html

Answer 2

It's much, much easier to do a save as.

Why does it have to stay open? - you can simulate it by:

• Doing a Save As to a new file
• Close the copy
• Re-open the original

As far as removing the code look at these questions:

http://stackoverflow.com/questions/704759/how-to-remove-excel-vba-code-modules-when-spreadsheet-opened-closed

http://stackoverflow.com/questions/680875/macro-to-save-active-sheet-as-new-workbook-ask-user-for-location-and-remove-macr