Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: compile error can't find project or library

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    John G
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am running Excel 2000 and I am having a wierd problem when I use mid or right string commands. Every time I have one of those 2 commands in my code I get "compile error can't find project or library" . Anybody have any clues? I'm fairly certain that I have everything correct because the code runs on another computer that I have excel 97 on.

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've experienced the same problem. No one knew what the problem was but I finally stumbled upon an answer. Open the VBA editor,and click on TOOLS > REFERENCES. you will get a list of available references and some of them will have check marks in front of them and one of these will probably say MISSING. uncheck the one(s) that say missing and you should be in business.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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