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

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 =---

Make reference to the object 9.0 libraries where, in
Excel 2002? I couldn't find it in the
references...please clarify!

Thanks
mika
-----Original Message-----
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 =---
.

If you wish to run the code in Excel 2000 then you need to select the
version 9.0 libary, there won't be a version 10.0 that was available in
Excel 2002.

So on your Excel 2000 machine, open the workbook, open VBE and select the
same object library v9.0, save the workbook and try to run the application.
If this did not utilise features only in v10.0 then you should be OK, esle
you need to change things.

You should be able to run the workbook back in your Excel 2002 environment
without change.

Cheers
Nigel


"mika" wrote in message
...
Make reference to the object 9.0 libraries where, in
Excel 2002? I couldn't find it in the
references...please clarify!

Thanks
mika
-----Original Message-----
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 =---
.





----== 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 =---