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

Thread: Compile error on a PC other than my own

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Adelaide, Australia
    Posts
    182
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am currently using an office and PC other than my own (that's another complaint for another messageboard at another time) and am getting a compile error on some code that has worked faultlessly in the past.

    The message is as follows:

    Compile error
    Can't find project or library

    The highlighted (and therefore erroneous) code is:

    chr

    This is in use for chr(13) to place a character return in a message box that has worked for the past 6 months, until I use this different PC. The different PC is the same make, model etc, also same version of Excel (97) and OS is NT.

    Can anyone please point me to the answer?

    Thanks in advance
    Stuart

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    Australia
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've had similar problems in the past, and it has always been related to Excel VBA object references. It has happened because on once PC the objects are located in a different place to the other.

    To fix it, hit Alt-F11 to bring up the Visual Basic Editor and click on Tools, References. You will probably see one or more errors in the list here and you'll need to Browse to find the right location of the object you're missing. Once you've found it, save the spreadsheet and it should be ok from that point on.

    Hope this helps,

    Penfold

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Adelaide, Australia
    Posts
    182
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Penfold.

    I performed task as you said, and have a missing reference:
    Microsoft Windows Common Control 6.0 (SP4)

    I am now embarking on a voyage of discovery as I try and find the bloody thing.

    Thanks again for your help.
    Stuart

  4. #4
    New Member
    Join Date
    Mar 2002
    Location
    Australia
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Stuart, have sent you a private message...

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
  •