Pega Robotics/Openspan: macro in .xlsm file should generically run in all the excel file(running excel macro from another workbook)
Pega Robotics/Openspan: How to run the macro(saved in macro-enabled excel file) in non-macro excel? macro should generically run in all the excel file in Pega Robotics?
Manually I can able to run the macro (saved in .xlsm) in Normal workbook(.xlsx file) , now trying to automate it via Pega Robotics. Any ideas?
Accepted Solution
Bank Of America
IN
Dear All, Thanks for your response and support, I have automated this and it is working fine, attached the screenshot of automation.
Bank Of America
IN
Pegasystems Inc.
US
This is probably more likely an Excel question. As far as I understand with Excel, the macro is part of the file. You wouldn't be able to execute a macro contained in another file with or without robotics involved.
Pegasystems Inc.
US
Macros can not be saved to a non-macro Excel sheet. In order to changes this do a "save as" and change the file type to .xlsm. Once you have saved the file type you will be able to save the Macro. Please note the macros are being called through Excel by Pega so we can not change the way Excel stores macros.
Comptech Associates Inc
US
You have the option to create/save macros in a macro-enabled spreadsheet in your profile area in a file that is usually called "Personal.xlsm". It's in Appdata-->Roaming-->Microsoft-->Excel if I remember correctly. So you can create your macro and save it in that directory with a known file name (e.g. MyExcelMacros.xlsm) and run it from there. It's a little trickier to write the macros for other spreadsheets, but it can be done.
Your other option is to write a script using Interop.
Accepted Solution
Bank Of America
IN
Dear All, Thanks for your response and support, I have automated this and it is working fine, attached the screenshot of automation.