Invoke VBA not working

Hi All,

Require urgent help in a scenario.

I am using Invoke vba activity in my process, it is working on xlsx files but not on xls files. I searched and found that uipath does not support invoke VBA activity in .xls files. I am stuck now how to achieve the task also i tried using Invoke VB script activity but using that nothing is happening in any of the files .xlsx/.xls.

Any help would be appreciated.


Well .xls is supported.

OK, but in my scenario it is working on .xlsx files and when trying to run on.xls files below exception occurs

RemoteException wrapping System.Runtime.InteropServices.COMException: Cannot run the macro ‘ListAllSheets’. The macro may not be available in this workbook or all macros may be disabled.

whereas the macros are enabled already

Can you post a SS of your Invoke VBA activity and can you send the VBA file ? (67.9 KB)

Please check the attached reference

In this the format i have used to save the file .xls

Please mark as solution if that helped you :slight_smile:

Hi @Dhruvi_Arumugam

You can try with the below dependency, checkout this thread


1 Like

Thanks a lot @Gokul001 @Ishan_Shelke1 I will try these and let you know

@Dhruvi_Arumugam When you are using invoke vba you should enable the below one . Did you try enabling that as well

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