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

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


"man" wrote in message
...
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