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,250 points
619 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.

answered Mar 7 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 2 days ago in RPA by Abha
• 24,400 points
14 views
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,110 points
1,784 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
• 13,400 points
965 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
3,676 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
220 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
242 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
426 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
343 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
• 320 points
2,811 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
415 views