Unprotect and Save a Password Protected Excel

[pranavred]

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
------------------------------

[pranavred]

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
------------------------------

[KennethBaleda]

may i ask for a copy of your solution? 🙂

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