My customer gets Excel files from the business, some of them are password-protected even if they shouldn’t. In that case, the goal is to detect this and generates an error report, otherwise the robot is blocked.
Consequently I would like to detect if an Excel file is password-protected before trying to read it. I found this post: Check whether excel is password protected?
But it does not work because the robot is blocked as soon as the “Use Excel File” activity executes. In fact, I have a “Excel Process Scope” activity that includes a “Use Excel file” activity with my sheet file name. When the “Use Excel file” activity executes, Excel starts, opens the file and waits for the password, and the robot does not go further.
Thanks for any help.