The macro may not be available in this workbook or all macros may be disabled


I am trying to invoke vba activity on .xlsm file inside excel application scope. When I run it below error has been displayed.

“The macro may not be available in this workbook or all macros may be disabled”

Sailaja Pasupuleti

1 Like


You have to enable it in settings. in the Trust Settings, please enable macros.

Files → Options—> Trust Settings ->Trust Center Settings -->Macro Settings → Enable all Macros

Vishnuvarthan P



I cant enable it manually. Access issue.

1 Like

This issue usually occurs when the file path mentioned in the excel application is not a macro enable excel file path
–either we need to enable the macro settings in that file path
–we need to mention the excel file path without a macro enabled one like simply a xlsx or xls file
–now inside the scope use a Invoke VBA activity where we can pass the macro script as string or keep the macro script in a text file and use read text file activity and get the output with a variable of type string and pass that string as input to the invoke vba

hope this would help you
Cheers @Sailaja_Pasupuleti


where we able to run them now
Cheers @Sailaja_Pasupuleti

Thanks. I am able to run now.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.