cannot find project or library

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

glyn - 23 Mar 2006 17:26 GMT

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 this Message

Chip Pearson - 23 Mar 2006 17:31 GMT

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.

Signature

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

>I have created a template in my verison of excel 2000, when
>testing it in
[quoted text clipped - 13 lines]
>
> Can anyone shed any light before I throw myself off the roof

Reply to this Message