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.
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 ?
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
You can try with the below dependency, checkout this thread
I have included a new activity in this package is called “Remove HyperLink”.
Let me if you have any error.
I would be happy to get more suggestions.
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.