Question

15
Replies
424
Views
Close popover
Dipesh Barakoti (DipeshB2)
Coforge BPM
Associate System Architect
Coforge BPM
US
DipeshB2 Member since 2018 5 posts
Coforge BPM
Posted: February 25, 2019
Last activity: March 13, 2019
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