Execute macro - Macro doesn't work the same as executed manually


#1

Hi guys,

I’m having a problem with Execute macro activity. I’ve noticed that using this activity macro doesn’t behave exactly as it should when executed manually by me from the excel workbook. That causes problems with the macro output data, there are some problems with Evaluate method (generates an errors in cells where this method was used) as well as activating a specific worksheet after all macro activities - I’ve noticed that it doesn’t work (that specific worksheet is not activated after macro activities). Should I try to setup the UiPath workflow so that it runs the macro “manually”, without the use of execute macro activity ? Thanks for any help !


#2

I’ve seen that too. Treat the workbook as what they are, objects, so instead of refereing to sheet.name only , activate the workbook.

Sometimes if you look carefully UiPath opens two excel files, right, try to kill the process manually before running UiPath, log that error, and see how many times happens and if it is necesary to add a kill process activity.

I guess to run a macro for complex process saves a good amount of time.

regards.


#3

Hi razor34,

I am facing the same issue as you. Are you able to resolve the problem?
If so may I know the solution? Thanks In advanced.

Regards,
Eric


#4

can we have a sample xlsm and workflow?


#5

Hello,

Please follow below videos
https://www.youtube.com/results?search_query=execute+macro+in+uipath+by+karthik_bethi

Thanks,