MS Project 2002 - VBA Compatibility w/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.
..

 

[Guest]

Upgrading to MS Project 2003 will fix this.

 

[JackD]

I use Project 2002 and Excel 2003 together without problems.
Perhaps it is not the excel library that is the problem.

Have you checked the other libraries? (OLE Automation, Microsoft Office ...)

-Jack