When the Bot ran it is giving the Error: Could not find the macro or all the macros are disabled

Help Studio
,
1

When the Bot ran in the Studio, it is giving the below Error:
Could not find the macro or all the macros are disabled

2

Hi @KVRMohan ,

Open excel, Go to Options → Trust center → Trust center settings → Macro settings

And enable VBA macros

image
image997×549 25.2 KB

1 Like
3

First of all thank you for your response.
But I had configured these settings already.
The problem is I am trying to copy Paste the .VB code from the Macros folder to the existing Excel I am creating a dummy macro and pasting the code there and saving it after that. But it was not appearing in the existing macro’s list.
Please help me.

4

Hi @KVRMohan

Can you try these steps-

  1. Check if the macro file is available in the specified location. If not, locate the file and move it to the correct folder.
  2. Check if the macro name is spelled correctly and is called correctly in your UiPath workflow. If necessary, correct the spelling or update the macro name in your workflow.
  3. If the above steps do not resolve the issue, try restarting UiPath Studio or your computer and then try running the workflow again.
5

@KVRMohan

First of all may I know why you are trying to do this?

And is the extension you are saving is xlsm?

Cheers