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

[Palaniyappan (Palaniyappan P)]

@Sailaja_Pasupuleti

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

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

Activities - Invoke VBA

hope this would help you
Cheers @Sailaja_Pasupuleti