Enable Macros not working Invoke VBA Activity

Help Activities
, ,
1

Hi I was testing something with macros using the invoke VBA Excel activity, I enabled Macros as shown in the screenshot

The image displays macro settings in Excel with VBA macros enabled despite a warning that it is not recommended due to potential security risks. (Captioned by AI)
The image displays macro settings in Excel with VBA macros enabled despite a warning that it is not recommended due to potential security risks. (Captioned by AI)899×435 7.08 KB

And I’m still getting the error, for context im trying to copy paste a table from an xlsb file to another.

I tried opening Excel as an admin and the settings are the same

This is the error I get:
Invoke VBA: In order for this activity to work, Trust Access to the VBA project object model must be enabled from Excel (File > Options > Trust Center > Trust Center Settings > Macro Settings > Select the Trust Access to the VBA project object model check box)

2

Hi @FilipeChiou

First check manually macro is working or not then

make sure Excel file is not opened before running the bot close all Excel processes then open Excel manually as admin and enable trust access to VBA project object model then run UiPath studio as admin and run workflow

4

@FilipeChiou

What’s the error you are getting?

5

Try converting the file to .xlsm and not .xlsb

6

@FilipeChiou,

Try this solution:

7

I cant do that it has to be in xlsb file

8

This applies in xlsm, I tried running invoke vba activity with xlsm files and it worked, however when turning to xlsb files it seems to have this error

9

Hi yes, I already tried that and still same error unfortunately

10

@FilipeChiou,

Ohh ok. I missed the xlsb extension part from your question.

Invoke VBA can’t run macro in .xlsb type file.

The image shows documentation for the UiPath Invoke VBA activity, which allows running macros on Excel files (.xls and .xlsx), with a note highlighting the need for enabling trust access in Excel's macro settings. (Captioned by AI)
The image shows documentation for the UiPath Invoke VBA activity, which allows running macros on Excel files (.xls and .xlsx), with a note highlighting the need for enabling trust access in Excel's macro settings. (Captioned by AI)1064×341 30.2 KB

Workaround?

  1. You can convert the xlsb to xlsx
  2. Execute the macro
  3. Again convert it back to xlsb