Save workbook as with password

[tousifmehaboob]

I want to save workbook with password. could any one let me know the code for this

[AmiBarrett]

Check this. https://exceloffthegrid.com/vba-code-password-protect-excel-file/

[pranavred]

I was trying to save the password protected excel, without any password (unprotect it. I have the password). I'm guessing there's no VBO for it.

------------------------------
Venkata Pranav Reddy Thathireddygari
Engineer
HedgeServ
America/New_York
------------------------------

[MelissaSuarez_G]

The MS Excel VBO has an action for this, it's called "Protect Workbook". You can pass the password and the workbook that you want to protect. ​However, if you want more functionalities, like specifying what you want to lock (like formatting, column width....) you will have to create your own action.

If you are asking, how to unprotect a file and then save it without a password, Blue Prism doesn't have an out of the box object for that. You can achieve it either creating an object that interacts with Excel UI (not recommended considering that the UI might change with new versions of Excel) or you can create your own code.

------------------------------
Melissa G.
America/New_York
------------------------------