How to run "Execute Macro" activity?

[Shyam_Prasad_Chakrab (Shyam Prasad Chakraborti)]

Why is this error coming?

[ranjith]

Hi,

Run the macro with prefix as “ThisWorkbook.YourMacroName” in Execute Macro Activity and enable the macro warning if it is shown while opening the worksheet manually.

If it doesnt works,Refer this post

Execute Macro from Personal Macro Workbook

Hi all, I am trying to use the Execute Macro activity to run a macro from my Personal Macro Workbook (PERSONAL.XLSB), but I encounter an exception, which I’ve included below. My input field for Execute Macro is as follows, where “JobsheetExport” is the macro name: “C:\Users\Daniel\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB!JobsheetExport” Here’s part of the error message (if the full message helps, I can post that too): Message: The range does not exist Source: Execute macro Ex…

Regards,
Ranjith.

[niteckam (PinkPanter)]

Hi,

We struggle wth the same issue.
We put the name on the macro and when it’s run we have error message Message: The range does not exist

[ClaytonM]

Have you tried removing “PERSONAL.XLSB!” from the MacroName?
Where it says “PERSONAL.XLSB” in the macro name, have you tried using the full filepath?

I’m not sure but thought maybe one of the two could fix it.

[asishkumar (Asish Kumar Behera)]

This error is coming as UiPath is unable to read the macro name from the xlsm (macro) file.

You can design the workflow like this, which will resolve the problem.

Here TestMacro is the Name of target macro which we wanted to execute from the xlsm file.

[karthik_bethi (karthik)]

hi,
pls follow below tutorial,

Execute Macro in uipath part-1

thanks,
Karthik.

[balupad14 (Balamurugan (BalaReva))]

Hi @asishkumar,

May I know the situation to use the macro ?

Regards
Balamurugan.S

[asishkumar (Asish Kumar Behera)]

Hi Balupad,

Well there are number of scenario where we can use macros, basically as part of back office automation where we needs to run macro.

1. If the excel macro is part of the Automation process
2. We can also write custom macro when we needs to perform some basic calculation or validation or reconciliation of the data in excel file.

Thanks,
Asish

[prvnmr679 (Praveen Kumar N)]

Do not use the same name for module as well as sub, because of this i was unable to execute my macro in Uipath.

[sharathraju489 (Sharath Raju)]

Guys,Here is a detailed article on that

How To Execute Macro – In UiPath

[Rakesh_Tiwari]

Hi,

How to know whether macro is executed properly or not, kindly make a video on that, coz i have been asked in one of the interview.

Thanks