Can't find project or library

G

Guest

Hi,

I am running a macro that I wrote a year ago. I didn't make any changes. But
it dosen't work this time!

The problem is, for all the variables I haven't defined explicitly, it gave
me an error message "Can't find project or library". What's more, when I was
using function
"Right("Excel", 4)", it gave me the same error message! And Now I have to
write
"Strings.Right("Excel",4)" to clear the error.

Could anybody give me suggestions to solve this problem? Thanks a lot!
 
R

RB Smissaert

You have a missing reference.
In the VBE do Tools, References and you will see what it is.

RBS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'Can't find project or library' error 7
Can't find project or library 3
Excel 2003 with VBA - "Can't find project or library" 6
Compile Error: Can't Find Project or Library 2
Compile Error: Can't find project or library 3
Can't Find Project or Library 2
Can't find project or library 3
Can't find Project or Library 1

Top