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

Hi,

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”

Thanks
Sailaja Pasupuleti

Hi

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

regards
Vishnuvarthan P

1 Like

Hi,

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
or
–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

2 Likes

where we able to run them now
Cheers @Sailaja_Pasupuleti

Thanks. I am able to run now.

2 Likes

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