uiPath and Excel Macro


#1

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


#2

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


#3

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)


#4

Hello,

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

Cheers,
Pankaj


#5

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


#6

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


#7

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

Cheers,
Pankaj