Posted: 20 Feb 2020 14:19 EST Last activity: 27 Feb 2020 8:59 EST
Excel xlsx Saveas .xlsm
I have a Automation process that opens an Excel XLSX file using the Excel Connector and then Modifies The Columns and Data and Then embeds a Macro to the Excel document using a C# Script process. But when I pass the filename with the extension .XLSM to the SaveAS process in the automation Excel Object I get a Popup Saying "The Following Features cannot be saved in a macro-free Workbook
To save this file with these features , Click No, and then Select a Macro-Enabled File Type
The Path / File name I'm passing to the SaveAS process ends in .XLSM
How can I open an Excel .XLSX and Modify to include Macros and then save as an .XLSM without prompting the User?