View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Can't find project or library

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

RBS

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