Results 1 to 4 of 4

Thread: Cannot Get PDFCreator code to Work

  1. #1

    Exclamation Cannot Get PDFCreator code to Work



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Seeker drocha's Avatar
    Join Date
    Feb 2012
    Location
    Porto, Portugal
    Posts
    5
    Articles
    0
    What's the error that is given you?

  3. #3
    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.

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,274
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •