Currently there is no pre-built VBO that allows you to save an Excel file with a password. The 'protect' action makes it read only, it does not require the password to view the file.
An update to the MS Excel VBO has been posted with a new optional parameter on the Save Workbook As, Save Current Workbook As, and Open Workbook actions to support specifying a password.
The latest Excel VBO can be downloaded from the Digital Exchange: https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo
That's a great update!
Where can I download this from?
Brilliant! Thanks
We added the feature yesterday based on your request. It was quick work, so we went ahead and published it. ;-)
Thanks for the update Eric, I wasn't aware of the new VBO. I'll check it out.
An update to the MS Excel VBO has been posted with a new optional parameter on the Save Workbook As, Save Current Workbook As, and Open Workbook actions to support specifying a password.