+ Reply to Thread
Results 1 to 2 of 2

cannot find project or library

  1. #1
    glyn
    Guest

    cannot find project or library

    I have created a template in my verison of excel 2000, when testing it in
    other versions of excel I have installed on a virtual machine I am getting
    the error message
    "cannot find project or library ", upon debugging the code I can see that it
    is falling down on the lines of code that use the following functions
    right()
    chr()
    as far as I can remember i have not got these functions from any add-ins or
    anything, they just came with my version of Excel.
    they are pretty standard functions

    Can anyone shed any light before I throw myself off the roof

  2. #2
    Chip Pearson
    Guest

    Re: cannot find project or library

    You'll get that error if a library is missing. In VBA, go to the
    Tools menu, choose References, and see if any are marked MISSING.
    If you don't need the missing library, uncheck it. If you do need
    the library, use the Browse button to navigate to the appropriate
    library.

    One method that may help you is the following: Close Excel. Go to
    the Windows Start menu, choose Run, and enter

    Excel.exe /regserver

    This will cause Excel to start, rewrite all its registry keys,
    and quit. Then, start Excel normally.


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



    "glyn" <glyn@discussions.microsoft.com> wrote in message
    news:BA5DC14E-144C-40E2-9EC2-5D84BD2E1948@microsoft.com...
    >I have created a template in my verison of excel 2000, when
    >testing it in
    > other versions of excel I have installed on a virtual machine I
    > am getting
    > the error message
    > "cannot find project or library ", upon debugging the code I
    > can see that it
    > is falling down on the lines of code that use the following
    > functions
    > right()
    > chr()
    > as far as I can remember i have not got these functions from
    > any add-ins or
    > anything, they just came with my version of Excel.
    > they are pretty standard functions
    >
    > Can anyone shed any light before I throw myself off the roof




+ 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