Excel Setup Sheet: Change to .xlsm w/ macros?

[Ethibaudeau]

I'm working with a modified version of the AutoDesk provided "setup-sheet-excel-2007.cps".

See attached "Doosan 2100LB SS 003.cps".

I'd like to have the Excel template be a .xlsm file with macros. However, I can't seem to figure out where in the post that the file extension is written out. The post runs, but outputs a ".xlsx" extension still. (If I change the file extension manually back to ".xlsm", the macros are still in there - so I'm close to having this working).

Where in this post is the file extension? Line 25 has "extension" but it doesn't appear to be used. I'm guessing it's somewhere in the low level XML lines of code, but my understanding is not great there. Thanks!

[Ethibaudeau · Accepted solution]

I was wrong, the Line 25 "extension" does in fact drive the file extension. I must have had it wrong earlier. It works now that I corrected that.