How to run macro with argument

[crazywindy]

I am trying to execute macro with argument in UiPath. However, looks like couldn’t give any argument. The execute activity was run without error, but no update to the excel. Does anybody has suggestion?
Here is the example I want to play. The macro will clear the specific sheet.

VBA:
Sub Empty_Sheet(ByVal sheetName As String)
Worksheets(sheetName).Cells.Clear
End Sub

[rahamtullah (Mohammed Rahamtullah)]

Hi @crazywindy,

Please refer these topics for help.

How to execute Macro with arguments

Hello, for the last few hours I’ve been trying to use Execute Macro activity and pass arguments but the macro doesn’t work as expected and I would appreciate some help. What I want to achieve is to copy a specific row, insert the copied row just below it, and insert a value in a cell of the new row. I’ve created a macro that works fine when running it from excel or when using Execute Macro activity without passing any arguments. But when I pass in a few arguments, even though the arguments are …

Execute Excel macro with argument throws range does not exist error

So, here’s the code in the XSLM file, Module1: Sub CloneTemplate(strName As String) 'strName = "wubba" Sheets("EXAMPLE").Select Sheets("EXAMPLE").Copy After:=Sheets(Sheets.Count) Sheets("EXAMPLE (2)").Select Sheets("EXAMPLE (2)").Name = strName End Sub Here’s the activity in my XAML: [image] Here’s the error: Source: Execute macro Message: The range does not exist Exception Type: ExcelException UiPath.Excel.ExcelException: The range does not exist ---> System.Runtime.…

Regards,
Rahamat

[crazywindy]

@rahamtullah thanks for response.
I tried the 2nd solution, enclosed the statement with single quote but it was not working, which returned error “Execute macro : The range does not exist”
For the 1st one, looks like the problem was not passing argument to macro.
Do you have working sample can be shared?

[crazywindy]

@rahamtullah
So weird. I can’t put the statement directly to commandtext of execute macro, but can use variable to pass the value
use

instead of

No idea why, but working now.

[rahamtullah (Mohammed Rahamtullah)]

Hi,

Is the macro running fine when you try to run it from excel manually.

Regards,
Rahamat

[crazywindy]

yes, working.