You’re offline. This is a read only version of the page.
31
Hi everyone,
I was wondering how are you handling Macro Errors with PAD, usually in other RPA tools we can retrieve the output values from the Macro and read them through the RPA application but in this case I just see that with PAD we can only send parameters but we can't receive.
Any ideas to know when a Macro fails?
Thanks!
Can you tell the macro to write a log file and PAD can read the log file? PAD will get stuck on a macro if the macro doesn't successfully finish; therefore, I would put an OnError in your macro, so it can write the error to a log file and end "successfully", so PAD can get out. Then I would have "if file exists [errorlog].txt" then take an action based off the contents of the file, but if it doesn't exist, then assume Excel Macro worked and move on.
Good luck!
Share
Report
All responses (
Answers (
