Excel to PDF with Password to view

[Incompuk]

Good morning,

I'm really needing some help on creating a Password Protected PDF using VBA. I need to do this for many files and already have a looped macro to create the PDF etc, just not password protect. Each file will also need to have a unique password found in a certain cell on the Excel file.

At the moment I've found some code to use PDF Creator but I'm using Excel 2013 and can;t even get past the "Dim pdfjob As PDFCreator.clsPDFCreator" without a User Defined Error.

I've enabled PDF Creator and Visual Basic in the references but still no luck.

Truly lost. Any help much appreciated.

 

[ww4612]

you can add this code before the pdf generation macro

if selection.value=xxx then
'code to generate pdf file
end if

 

[Incompuk]

Hi, Thanks for the response, not quite sure how this helps though. When I step through the macro it's the Dim pdfjob As PDFCreator.clsPDFCreator that creates the user defined error.

 

[ww4612]

can you make your pdf generation code work without password?
i am not sure what method you use to generate the pdf file. i would use the save as option of save the entire or part of them sheet in pdf format.

 

[Incompuk]

I can generate the PDFs no problem using excel, but using PDF Creator I can't even generate. The problem with using the Excel Save As method is that you can't password protect the PDF files.