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,270 points
704 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 Oct 14 in RPA by Abha
• 27,200 points
90 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,875 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,960 points
1,149 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,982 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
261 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
313 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
491 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
403 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,997 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
455 views