1
Vote

Does not create an Excel 2007 Macro-Enabled Workbook

description

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

comments

mischab1 wrote Jul 27, 2010 at 12: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 1:25 AM

wrote Dec 30, 2013 at 10:29 AM

pavzaj wrote Dec 30, 2013 at 10:29 AM

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

Updated version attached