Reply With Quote
What's the error that is given you?
Cannot Get PDFCreator code to Work
I am trying to use the code provided in earlier forums to print an excel bill of lading to a pdf file using PDFCreator. I am not very knowledgable in VBA and what I know, I taught myself. I am using excel 2010.
The part of the code that keeps giving me an error is:
Dim pdfjob As PDFCreator.clsPDFCreator
and...
Set pdfjob = New PDFCreator.clsPDFCreator
Basically anything that has the PDFCreator.clsPDFCreator in it.
What's the error that is given you?
You need to install PDFCreator and then in VBA go to Tools>References and scroll down to select "PDFCreator"
Let me know if this did it.
Steps to do what p_smith suggests: http://www.excelguru.ca/content.php?...pe-Not-Defined
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Bookmarks