Consulting

Results 1 to 6 of 6

Thread: Cannot Find Library

  1. #1

    Thumbs down Cannot Find Library

    I developed an app in VBA for office 2003. I tested and sent it to a client. Works fine on my machine but compiling or running it on their machine give the error "Cannot Find Library". It then highlights the function LCase$. I tried using LCase$ in the immediate window and it gives me the same error. I open the object browser (F2) and browse VBA. The String library shows as does LCase$ and LCase. I tried using a number of the functions in the string library (Left$, Right$, Mid$, etc.) and they all give me the same error. The client had installed Office 2007 so we moved over to another machine that had 2003. Same problem. Other functions and statements execute but none of the string functions. I've never seen the likes. Any ideas?

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    This is usually caused by a missing reference.

    Go into the VBIDE, then goto Tools>References. If there are any items with MISSING in them, unchcek them, and see if that solves the problem.

  3. #3
    Thank you for your reply.

    I have checked the references and none are marked as missing.

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Can you post the workbook here?

  5. #5
    It's a Word document. Not sure how to do that in this forum.

  6. #6
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    you can attach your word document by hitting post reply at the lower left of the last post...when the page comes up type your message then scroll down till you find a button that says manage attachments.
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

Posting Permissions

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