Question

1
Replies
230
Views
Stephen Brown (StephenB7988)
Bank of America

Bank of America
US
StephenB7988 Member since 2019 2 posts
Bank of America
Posted: February 20, 2020
Last activity: February 27, 2020
Posted: 20 Feb 2020 14:19 EST
Last activity: 27 Feb 2020 8:59 EST
Closed
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 Enterprise Application Development Dev/Designer Studio Financial Services Scrum Master
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.