Run macros from Excel file using Invoke VBA

Help Studio
1

Hey guys,

Can someone advise why when I use Invoke VBA activity to run macros from Excel file it is getting an Error: Invoke VBA: Cannot run the macro ‘Example1’. The macro may not be available in this workbook or all macros may be disabled.
I enabled macroses in the workbook before running the process in UiPath and macros works when running from Excel file, but gets error in UiPath.

2

HI @Apple1,

Can you please share your vb code so that i can have a look secondly have you enabled Allow macro in the excel Trust center settings ?