Open password protected Excel spreadsheet with UiPath

Question

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.

Really flummoxed!

Answer 1

Its fairly simple you need to Update the Excel Activities, Use the new Excel Application Scope and then Set the password property.