Can I pass Parameters in Execute macro Activity If Yes then how. Please help

[ankitg (Ankit Gupta)]

Hi

I am using a Execute macro activity in uipath studio but without passing parameter it is working fine and call a macro performing operation as desired.
Although when i am passing parameters in it and updates in excel macro as arguments it is getting me ERROR Like

Execute macro : Cannot run the macro ‘Chat_Message(“C:\Users\a0734941\Documents\Kuldip sir\Quick chat rebuilt”,“AllianceRx Service Connect Client Specific Business Requirements (HR BPO).xlsm”)’. The macro may not be available in this workbook or all macros may be disabled.

In case of parameters am i getting an error.

Thanks
Ankit Gupta

[balupad14 (Balamurugan)]

Hi @ankitg,

May these help you.

Executing a Macro by passing a string parameter

hi @PJain you can use the below code and let us know Sub SheetKiller() Dim s As Worksheet, t As String Dim i As Long, K As Long K = Sheets.Count For i = K To 1 Step -1 t = Sheets(i).Name If t = "ID Sheet" Or t = "Summary" Then Application.DisplayAlerts = False Sheets(i).Delete Application.DisplayAlerts = True End If Next i End Sub Thanks Ashwin S

Passing Argument to Excel Macro

We have Execute Macro activity, We can have the option where we can pass arguments to Excel Macro directly. I have seen the functionality in other RPA tool.

Regards
Balamurugan

[KEntwistle (Katie Entwistle)]

Hi

There is a “hack” that can do it but I’ve found it unreliable. The most reliable way for me is the robot writing the parameter into a config file and then having the macro read the config file at the start of execution.