Create protected PDF using macros

[Krishna20]

Hi,

I have created a pdf from Excel using VBA and I found some codes, wherein we can protect the excel sheet. But, can we create a password protected PDF using VBA?

Thanks
Krishna

 

[lohithsriram]

Hi Krishna,

Please try the below link which has a VBA code to protect the PDF with password. However it requires a PDFCreator reference to make it work easy. If this doesn't work, please post your code of PDF creation as I can give a try to check for the security options. Thanks.


http://www.excelguru.ca/content.php...ptions-set&s=493180c8e8acf45405305176b0a8a931

 

[Krishna20]

Thanks Lohit,

But I think this doesnt work with adobe. Can we use VBA to manipulate Adobe Acrobat?

Thanks
Krishna

 

[SirJB7]

Hi, Khrisna20!
Tried yet at Adobe forums like these?
http://forums.adobe.com/message/5849866
http://answers.acrobatusers.com/OLE-automation-Acrobat-10-q119190.aspx
And this is a good starting point, a tutorial from Kremer (Karl H.):
http://www.khk.net/wordpress/2009/03/04/adobe-acrobat-and-vba-an-introduction/
Hope it helps.
Regards!

 

[Raj Mohan]

Hi Krishna,

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 solomraj@gmail.com

Thanks and Regards

Raj Mohan