Generating password-protected PDF using Excel VBA

[man]

Hi all,

I would like to generate password-protected PDF using Excel 2003 VBA.
It can't be manually done using Acrobat Professional becuase I have to
do it a hundred times everyday, and each PDF would have a different
password. My computer has been installed an Acrobat Professional 8.

Anyone knows how to do this? Thanks.

Cyrus

 

[RB Smissaert]

If you download and install the free PrimoPDF then you can do things like
this:

Sub test()

Sheets(1).Activate
Application.ActivePrinter = "PrimoPDF on Ne04:"
ActiveWindow.SelectedSheets.PrintOut _
Copies:=1, _
PrintToFile:=True, _
PrToFileName:="C:\mytest.pdf"

End Sub

Not sure about the password.


RBS