Does not create an Excel 2007 Macro-Enabled Workbook


Title says it all. Solution is slightly more complex - I think perhaps different builders may be needed to cater for different Excel versions.

file attachments


mischab1 wrote Jul 27, 2010 at 1:35 AM

I don't know about other versions of Excel, but in Excel 2007, you can fix the problem by specifying the 2nd parameter of SaveAs.

If you want.. Then use
Extension XlFileFormat
xlsm xlOpenXMLWorkbookMacroEnabled
xls xlExcel8

wrote Feb 14, 2013 at 2:25 AM

wrote Dec 30, 2013 at 11:29 AM

pavzaj wrote Dec 30, 2013 at 11:29 AM

One more thing, you need to save workbooks programatically with "fileFormat" argument set to "52".

Updated version attached