Hello @niteckam according to the official StudioX documentation ( https://docs.uipath.com/activities/docs/execute-macro-x#section-studiox) when you want to execute a macro one should add an Excel file card and point it to the xlsm file that contains the macro, then add a run macro activity and configure the following:
- Source workbook – the file which contains the macro
- Macro name –
- Output – if any because some macros have no output
- Arguments – the arguments of the macro ( could be none ))
Also attached you will find a test project . The xlsm contains 3 macros - one just displays in a message box a test ( similar to the classy hello world ) one uses parameters and based on the parameter displays a text and the third based on the parameter returns the sum of the parameter and 1 .
NewBlankTask47.zip (94.8 KB)
Hope this helps