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

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" wrote in message
...
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