Unique Password Protect PDF (by batch), using excel VBA without 3rd Party program

[radian89]

Dears,

i have searching all over, but couldn't find this answer. i need to automate protect PDF each will have unique password. all in googles refer to install 3rd party, but that applied 1 password for all.

then read this

https://www.codeproject.com/Tips/992992/VBA-Excel-Word-to-PDF-Encrypted-Password-Protected

and found error 429 : ActiveX component can't create object. i run this on Excel 2016 32-bit

and if there are any other method would you mind to share?

please help
thanks so much.

 

[Jeffrey Mahoney]

Please post the code you have in Excel. The code from that site, I think, was designed for WORD.

 

[Macropod]

Not only is the code in the link for Word, not Excel, it also uses a 3rd-party dll. You cannot protect PDFs with MS Office alone.