Scenario: Robot opens an excel file and executes a VBA macro defined in it. Macro saves the result in an output file already present in the file system. When the output file is a read-only file, Macro process fails.
Problem: When we compare the behavior when the above scenario is executed by Robot and manually by User, the error code is same but there is a difference in error messages displayed. This causes the error handling automations due to matching failure as the message text differs. Please refer the attached Excel file with screenshots of error messages. (Left side is manual, right side is when Robot executes it.)
I used to think that Robot won't modify the error messages native to the VBA macro, but that doesn't seem to be the case. I don't think that this is correct product behavior. If it is correct, may I know what is the thought process behind doing it and how is it achieved?
***Moderator Edit-Vidyaranjan: Updated SR details***
Currently have advised the team to go for the error code ('1004'), as thats the common thing. However, we have been asked about the root cause for the difference in error messages. It continues to baffle me, as I am able to regenerate it 100%, and yet have no clue why its happening the way it is.