topic RE: Unprotect and Save a Password Protected Excel in Product Forum

Unprotect and Save a Password Protected Excel

pranavred — Tue, 11 Jun 2019 15:20:00 GMT

Hi,

I'm able to edit the MS Excel VBO to open a password protected file. But when I use "Save As Workbook", after opening the file with the password, it's still saved in protected mode.

My goal is to save the files without needing any passwords. What's the best way to do this?

Thanks,

Pranav

------------------------------
Pranav
------------------------------

RE: Unprotect and Save a Password Protected Excel

pranavred — Tue, 11 Jun 2019 19:14:00 GMT

Ok, struggled with Excel VBO (Protect Workbook, Unprotect Workbook actions) for a few hours and decided to go with PowerShell. Used similar code as below.

https://stackoverflow.com/questions/42860894/remove-known-excel-passwords-with-powershell

I'm passing file names and password as arguments through a batch file. I'm writing the batch file in Blue Prism using "Write to Text" with .bat extension.

This works, but if anyone made it work using only Blue Prism, I'd love to see.

Cheers!

------------------------------
Pranav
------------------------------

RE: Unprotect and Save a Password Protected Excel

KennethBaleda — Wed, 11 Oct 2023 20:26:00 GMT

may i ask for a copy of your solution? 🙂

------------------------------
Kenneth Baleda
------------------------------