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

Help
1

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

1 Like
2

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

2 Likes
3

Hi,

I cant enable it manually. Access issue.

1 Like
4

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

3 Likes
5

where we able to run them now
Cheers @Sailaja_Pasupuleti

6

Thanks. I am able to run now.

2 Likes
7

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