Unable to execute macro and how to click macro button

Help Activities
,
1

Hi,
I have tried the function execute macro but not successful. It says "The macro may not be available in this workbook or all macros may be disabled. However, marco is in this workbook and the option all macros are enabled is "on”。 My file is .xls format.

Also, I have tried “the click and click image” to click the button of macro in the worksheet. but it is also not successful.

May I ask for help? Thanks

Francis

2

Does xls file support macros? I am not sure about this, but I suggest that if you use macros, you can try Invoke VBA Activity, or use xlsm files, hope it will help you

3

Hi @Francis_M_H_Tse,

Use the Invoke VBA activity, inside Excel Application Scope activity to run the Macro from Studio.

image

in_imagesExcelPath - Path of the Excel on which you to run Macro.

Sample.vba - Path of your VBA script.

Sample - Function name in your VBA Script.

Invoke VBA supports xls format