Unable to exceute macro in uipath

[Bhagyashri (Bhagyashri hadule)]

Unable to run macro through uipath

[Lahiru.Fernando]

Hi @Bhagyashri

Have you enabled the macro execution in the file? Does it run when you do manually ?

[Bhagyashri (Bhagyashri hadule)]

yes i tried running it manually its working fine there…

[Lahiru.Fernando]

Try this and see

Invoke VBA

I am using Invoke VBA to call a VBA Function in an Excel File. I have it setup as follows: Excel File (.xls) file with no Macros Excel is configured to allow macros A separate file with the Macro Code When I use the Invoke VBA activity it comes up with the following error: Cannot run the macro ‘SelectSheetContents’. The macro may not be available in this workbook or all macros may be disabled. To me that suggests the VBA Function needs to be in the Excel File, but I thought that is what th…

[Bhagyashri (Bhagyashri hadule)]

Thanks,
It worked for me