Invoke VBA not working

[Dhruvi_Arumugam]

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.

Thanks

[Ishan_Shelke1 (Ishan Shelke)]

Well .xls is supported.

Invoke VBA

[Dhruvi_Arumugam]

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

[Ishan_Shelke1 (Ishan Shelke)]

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

[Ishan_Shelke1 (Ishan Shelke)]

Demo.zip (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

[Gokul001 (Gokul Balaji)]

Hi @Dhruvi_Arumugam

You can try with the below dependency, checkout this thread

BalaReva.Excel.Activities

Hi Friends, I have included a new activity in this package is called “Remove HyperLink”. Namespace. [image] Properties [image] Let me if you have any error. I would be happy to get more suggestions. Regards Balamurugan.S

Regards
Gokul

[Dhruvi_Arumugam]

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

[ushu (Usha kiranmai)]

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