Creating Password protected PDF files

raj.schummi

New member
Joined
Jul 12, 2012
Messages
2
Reaction score
0
Points
0
Hi,

I have a requirement of creating password protected PDF files from excel database. Each PDF file will have to extract from 2 excel worksheets, the selection of these 2 worksheets will be from the available multiple sheets. I have tried the PDFCreator way & stuck with the code as its not generating the 2nd file.

Can somebody please help me with this? Thank you in advance.

Regards,
Raj
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,524
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Can you post the code you're using and a sample file? Remove all the sensitive data, as the contents are not important to us, just the macro that you're using.
 

raj.schummi

New member
Joined
Jul 12, 2012
Messages
2
Reaction score
0
Points
0
I managed to rectify the code & its working absolutely fine, Thanks Ken

Cheers,
Raj
 
Top