+ Reply to Thread
Results 1 to 3 of 3

Compile Error When Saving as PDF

  1. #1
    Registered User
    Join Date
    08-14-2007
    Posts
    27

    Unhappy Compile Error When Saving as PDF

    Experts,

    I have the below code to save a workbook in PDF to the user's desktop with a file name from a cell value. When I send this workbook to a coworker, the code crashes, saying "Compile Error: Can not find project or library." Yet, the code works fine on my machine. I have had the user install the "ExceltoPDF" addin from Micrsoft and also uncheck the "Rely on system fonts only; do not use document fonts" setting on Adobe PDF. Can anyone please tell me how to fix this? Thanks.

    Please Login or Register  to view this content.
    Last edited by wealthistime; 03-28-2011 at 10:07 AM. Reason: Solved

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,982

    Re: Compile Error When Saving as PDF

    Open the workbook on the user's machine, open the VB EDitor and check under Tools-References for anything listed as 'MISSING:'
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    08-14-2007
    Posts
    27

    Re: Compile Error When Saving as PDF

    Woops, simple mistake. I forgot the DIM argument at the top. Problem solved! Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1