Macro

Hi
How to run excel macro in modern as there is no excel scope or execute macro in modern activities. Please share an example.

Thanks

Hi,

Can you try RunSpreadsheetMacro activity as the following?

Regards,

Thank you, @Yoichi
In Studio 2020.x there is no “Run Spreadsheet” activity. How to run the macro?

Thanks a lot,

Hi,

It might be necessary to turn on ShowStudioX at Filter in Activities panel and/or update Excel package to higher version.

Regards,

@Yoichi
Thank you. Please advise if it is a recommended practice to upgrade Excel package to higher version whether it would cause any issues?

Thank you,

Hi,

In this case, it’s better to try “ShowStudioX” first.
As there might be some different behavior b/w package version, recommended to test if upgrade it in existing project. If you try to start to create new project, it will work with less care.

Please note that it’s better to decide version in organization from a view point of governance.

Regards,

@Yoichi
Will try this. Thanks for the suggestion.

Just wondering how come Uipath users do not have options using macros in this version 2020.x

Many Thanks,

@Yoichi
Included classic design. Thanks