Password protected PDF file

[Dion.DAn]

I need some vba code for converting excel to password protected PDF file. I am using Excel 2010, no problem creating the pDF file with ExportAsFixedFormat but how can we password protect it??

Daniel

 

[wigi]

Hello

See here: http://social.msdn.microsoft.com/Forums/en-SG/exceldev/thread/a26cae16-f039-4bb9-9b15-8016b7d0965a

Another very good source is Ken Puls' website: http://www.excelguru.ca/list.php?category/75-PDF-Creator-VBA-Programming. That one uses www.pdfforge.org

 

[Dion.DAn]

It seems it can be done with PDFCreator I will try it thks.

Daniel

 

[Dion.DAn]

It worked like a charm, thank you

Daniel

 

[wigi]

Thank you for the update and the feedback.

 

[solomraj]

Hi ,
Protection of PDF using VBA is possible in 2 ways
1. We can protect the existing PDF which is already there
2. We can create PDF using excel and then Protect
You need adobe professional version to be installed. You have to create SecuritySettings Object, ConversionSettings Object and PDFMakerApp object.
Using the 3 object linked to each other we can lock the pdf. If you would like to know more details please email me
Thanks and Regards
Raj Mohan