+ Reply to Thread
Results 1 to 3 of 3

Compile Error: Strange happening

  1. #1
    Don Rouse
    Guest

    Compile Error: Strange happening

    An Excel app written using 2002 worked fine (at first) when loaded to a
    network and tested on PC's using 2002.

    But a PC with 2003 returned a "Compile Error: Can't find project or
    library." Then when going back to the 2002 PC's, I get the same compile
    error.

    Can anyone help me with this?

    Also, the test on the PC with 2003 caused the name of a named range to
    disappear.

    Strange happenings.

    Thank you for your assistance.
    --
    Don

  2. #2
    Chip Pearson
    Guest

    Re: Compile Error: Strange happening

    On the problematic PC, go to the VBA Editor, Tools menu,
    References. Look for any marked 'MISSING' and, if possible,
    remove them.


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "Don Rouse" <[email protected]> wrote in message
    news:[email protected]...
    > An Excel app written using 2002 worked fine (at first) when
    > loaded to a
    > network and tested on PC's using 2002.
    >
    > But a PC with 2003 returned a "Compile Error: Can't find
    > project or
    > library." Then when going back to the 2002 PC's, I get the
    > same compile
    > error.
    >
    > Can anyone help me with this?
    >
    > Also, the test on the PC with 2003 caused the name of a named
    > range to
    > disappear.
    >
    > Strange happenings.
    >
    > Thank you for your assistance.
    > --
    > Don




  3. #3
    Don Rouse
    Guest

    Re: Compile Error: Strange happening

    Thank you, Chip.
    --
    Don


    "Chip Pearson" wrote:

    > On the problematic PC, go to the VBA Editor, Tools menu,
    > References. Look for any marked 'MISSING' and, if possible,
    > remove them.
    >
    >
    > --
    > Cordially,
    > Chip Pearson
    > Microsoft MVP - Excel
    > Pearson Software Consulting, LLC
    > www.cpearson.com
    >
    >
    > "Don Rouse" <[email protected]> wrote in message
    > news:[email protected]...
    > > An Excel app written using 2002 worked fine (at first) when
    > > loaded to a
    > > network and tested on PC's using 2002.
    > >
    > > But a PC with 2003 returned a "Compile Error: Can't find
    > > project or
    > > library." Then when going back to the 2002 PC's, I get the
    > > same compile
    > > error.
    > >
    > > Can anyone help me with this?
    > >
    > > Also, the test on the PC with 2003 caused the name of a named
    > > range to
    > > disappear.
    > >
    > > Strange happenings.
    > >
    > > Thank you for your assistance.
    > > --
    > > Don

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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