uiPath and Excel Macro

Hi,

I recently encounter an issue with Macro was running fine and all of a sudden uiPath fails to call the macro.

image

It was working fine and then all of a sudden, none of the macro is working. I have check there are not macro security changes to the file. etc

Let me know if you have encounter a similar issue, and would like to share your experiences.

Regards,
Nelson

Have you checked your excel file is that having macro or not?

I had similar issue with invoke VBA code whenever the file would be opened or the excel process would stay in the background (maybe locking the file and blocking the macro)

Hello,

did you change your file extension from book1.xlsm to book.xlsx or something else?

Cheers,
Pankaj

no, changes, just a simple bug fix inside the macro function

restarted the machine/VDI which is running the Robot and still not resolve, it just stop working

Okay
have you taken backup. If you have backup and execute macro again. and let’s see an error.

Cheers,
Pankaj

Having the same issue with Windows 10 and Excel 365