Re-save Macro-Enabled Workbook as an xlsx file in VBA

K

KeriM

I have a macro enabled workbook that I'm using as a template for my mai
report. After I finish with the template, I would like to save th
workbook again as an xlsx file. I can usually do this in excel when I'
not running code, I just have to agree to remove the macros from th
workbook.

Unfortunately, when I try to do this with my VBA code, I keep getting a
error message on my VBA code saying that it can't save the file in tha
format. Is there a way around this
 

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

Working outlook via vba code with xlsx - error 0
Save workbook without shapes 0
Need Help with Macro Security 1
forcing specific sheet opening upon launch of .xlsx file 4
Autonumber field in Excel that behaves the same as Access 0
Menu Macro Not Executing - Need Help 1
how to avoid user to save in .xlsx 3
Excel 2003 save as .XLSX 12

Top