topic RE: MS Word VBO - ExportPDF - How to set password during export in Product Forum

MS Word VBO - ExportPDF - How to set password during export

ManishKumar3 — Sat, 27 Oct 2018 16:55:00 GMT

Hi, While exporting doc to pdf, i need to password protect pdf. Any help is well appreciated. Thanks.

RE: MS Word VBO - ExportPDF - How to set password during export

InJoeKhor — Thu, 13 Aug 2020 22:25:00 GMT

Hi Manish,

You can use Utility - PDF to set password on pdf.

Here is the link to the Utility.
https://digitalexchange.blueprism.com/dx/entry/58413/solution/utility---pdf

Cheers,

------------------------------
In Joe Khor
Sr. Product Consultant
Blue Prism
------------------------------

RE: MS Word VBO - ExportPDF - How to set password during export

MadhurChopra — Sat, 29 Aug 2020 02:47:00 GMT

Hey Manish,

Are you using the Word VBO to export to PDF? If so, I am afraid there is no way to password protect the PDF. Office's Object Model does not support encrypting PDF on export that can be called leveraged in the VBO, as can be seen at https://docs.microsoft.com/en-us/office/vba/api/word.document.exportasfixedformat.

Since yours is a specific use case, I'll suggest spying all necessary elements of the Word application and then using them as part of your automation to specify Encrypt options and the password.
The process is File > Save As > More Options... > Save as type: PDF (*.pdf) > Options... > Encrypt the document with a password > OK > Enter password > Re-enter password > OK > Save

I tried spying the elements and was successfully able to do so using UI Automation and Accessibility modes. I will suggest Accessibility mode as I found it to work better.

Hope this helps.

Regards.

------------------------------
Madhur Chopra
Sr. Product Consultant
Blue Prism - Professional Services
America/Los_Angeles
------------------------------