View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_6_] Nigel[_6_] is offline
external usenet poster
 
Posts: 68
Default Excel 2000 /2002 library problems

Make a reference to the object 9.0 libraries and try again you might find it
will work depending on what features are being used. I had similar problems
using the outlook 10.0 library after installing in an Excel97 environment.
I made reference to outlook 8.0 and everything worked OK.

Otherwise I guess you'll have to modify the code!

Cheers
Nigel


"mika" wrote in message
...
Hi,

I modeified an excel spreadsheet in excel 2002 and now am
trying to work with it in 2000. I have vba code in it.
However when i try to open it in excel 2000 on a
different computer i get compile error: project or
library not found. I was looking at the differences in
the library references and i believe that excel 2000 only
had the object 9.0 libraries while excel 2002 was using
the obejct 10.0 libraries. What can i do to make my code
work in excel 2000?? Thanks so much.

Mika





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---