Question

15
Replies
375
Views
DipeshB2 Member since 2018 5 posts
Ruletek LLC
Posted: 1 year ago
Last activity: 1 year 6 months ago
Closed
Solved

Protect/Unprotect password protect excel worksheet

I am trying to automate a password protected excel workbook. I was able open a password protected workbook with Open Method (4 parameters) but after that worksheet is also protected with a Form button in worksheet itself. I need to unprotect the worksheet as well. There is a Macro assigned to that button which I was able to run with RunMacro method to open “Enter Password Form” but after that the whole automation stops until I manually type the password and click “OK” or “Cancel”. I thought I was able to type password using SendKeys method but the automation doesn’t move to the next step so that I can use SendKeys. Also, I was not able to interrogate the textbox in the form just part of the form only (I am aware of limitations of interrogating an excel workbook). Please find the attachments on what I have tried so far. Let me know if you have any solution or suggestion to my problem.

***Edited by Moderator: Pallavi to update platform capability tags***

***Edited by Moderator Marissa to update SR Details***

Security Robotic Process Automation SR Created
Moderation Team has archived post
Share this page LinkedIn