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,280 points
349 views

2 answers to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

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

answered Aug 6, 2018 by wrecker
• 3,090 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.

answered Mar 7 by AllisonE
• 180 points

Related Questions In RPA

0 votes
1 answer

Writing multiple column in excel UiPath

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

answered May 9, 2018 in RPA by wrecker
• 3,090 points
1,041 views
0 votes
4 answers

Pivot table in excel using UIpath

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

answered Feb 25 in RPA by Anvi
• 5,960 points
546 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,090 points
2,305 views
0 votes
1 answer

Add filter to excel table in UiPath

If you use *my value as the ...READ MORE

answered May 16, 2018 in RPA by wrecker
• 3,090 points
928 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,090 points
137 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,090 points
97 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,090 points
237 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,090 points
190 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 in RPA by Venkat
• 260 points
1,488 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,090 points
248 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.