Project 2002 - VBA Compatibility with MS Excel 2003

[Guest]

I had MS Office 2000 or 2002, and MS Project 2002.

I built macros in MS Project 2002 that opened and
manipulated MS Excel, so of course in References, the MS
Excel object library (version 10?) was included.

I upgraded to MS Office 2003, but left my MS Project 2002
alone.

When I try to run my macro, I get the error
message "Compile error: Can't find project or library"

When I go into References, it has the Microsoft Excel
11.0 Object Library selected and the file it points to is
the same as when I actually open MS Excel 2003 and check
where its reference to that library is pointing.

Any ideas?

I will try to upgrade to MS Project 2003... I'm waiting
on access to the upgrade on our shared server, but in the
meantime, I'm wondering if that will even fix it.

 

[Mike Glen]

Hi ???????????,

Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://www.mvps.org/project/.

Mike Glen
Project MVP