Open password protected Excel spreadsheet with UiPath

0 votes
I was wondering if anyone had succeeded in opening a password protected XL spreadsheet with UiPath.

I tried using "Open Workbook" and entering the password in the password field ... but that didn't work.

I tried using Open Application ... but I can't seem to talk to the password dialogue box.
Aug 6, 2018 in RPA by Vardy
• 2,360 points
2,045 views

2 answers to this question.

0 votes

Update the Excel Activities. Use the new Excel Application Scope. Set the password property.

answered Aug 6, 2018 by wrecker
• 3,110 points
This doesn't work that way, tested it in versions from 2018.2.2 to 2018.4.1 still if you set the password correctly and open excel , do some actions there like, click menus, color sells etc.. then if you use save workbook activity it doesn't save the file....
0 votes

Want to open Excel, the first thing to consider is to remove Excel protection password is not it? If you are using Older Versions, you can solve the problem of unlocking the Excel password by using File Extension, VBA Code, and VBA Project. Here are the steps for the VBA code:
1. Open the Excel > shortcut "Alt + F11" to open the VBA Editor > right click on Excel File > Insert > Module in the Project-VBAProject pane.
2. Enter the following VBA code into the General window.

3. Click the Run button to run it > Pop up the password consisting of the letters A and B.

Gain expertise in robot process automation (RPA) tools and concepts by obtaining RPA with UiPath certifications.

answered Mar 7, 2019 by AllisonE
• 180 points

Related Questions In RPA

0 votes
1 answer

How to open an excel file with a dynamic file name such that the file name is FXTB-(date today) using UI Path.

Hey Alza, I am trying to understand ...READ MORE

answered Oct 14, 2019 in RPA by Abha
• 28,100 points
3,566 views
0 votes
1 answer

Writing multiple column in excel UiPath

You can read the entire Excel sheet ...READ MORE

answered May 10, 2018 in RPA by wrecker
• 3,110 points
2,604 views
0 votes
4 answers

Pivot table in excel using UIpath

You can use Create Pivot Table activity ...READ MORE

answered Feb 26, 2019 in RPA by Anvi
• 14,170 points
3,569 views
0 votes
1 answer

Running a UiPath process with a script

You can run any process in PowerShell ...READ MORE

answered May 16, 2018 in RPA by wrecker
• 3,110 points
5,923 views
0 votes
1 answer

UiPath - Citirx Automation

best way to do that is to ...READ MORE

answered Apr 13, 2018 in RPA by wrecker
• 3,110 points
683 views
0 votes
1 answer

UiPath - Web Scraping

Multiple solutions are listed below: Check your Selector Use ...READ MORE

answered Apr 13, 2018 in RPA by wrecker
• 3,110 points
986 views
0 votes
1 answer

Robot Manager in UiPath

the robot.exe file is located in: C:\Users\USER_ACCOUNT\AppData\Local\UiPath\app-17.1.6523\Ui-Robot.exe Hope it ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
1,041 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
939 views
0 votes
2 answers

change a specific column of an excel sheet in UiPath

1. First of all , you need ...READ MORE

answered May 16, 2019 in RPA by Venkat
• 320 points
4,599 views
0 votes
1 answer

Private Chrome window open UiPath

To open the browser in private mode, ...READ MORE

answered Apr 25, 2018 in RPA by wrecker
• 3,110 points
975 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP