Question

1
Replies
138
Views
StephenB7988 Member since 2019 2 posts
Bank of America
Posted: February 20, 2020
Last activity: February 27, 2020
Solved

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

.VBProject

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?

Pega Robotic Desktop Automation Low-Code App Development Dev/Designer Studio Financial Services Scrum Master
Share this page LinkedIn