Compile Error

[Guest]

I am currently using Excel 2002. I was given a file, apparently created in
Excel 2003. When I try to access the file I get the following message:
Compile error:
Can't find project or library
The developer believes this error is coming up because 2002 doesn't have the
same "libraries" as 2003 and that I need to upgrade to 2003. Any suggestions?

Thanks for any help.

 

[mattyboy150279]

Does the file you have been given contain VBA code? If so, then it
would seem that the original creator has 'referenced' another project
or library in it.

To explain, when this sheet has been created somebody has used code
from another sheet or a library of code (usually a dll file).

To isolate the problem, press Alt + F11 to open the code window and go
to tools>references. Here you'll get a list of other files that the
workbook refers to and hopefully you should see something like the word
'missing' against one or more checkboxes. You may need to speak to the
person that created the sheet if my solution below doesnt work.

Im guessing that the problem will be that the missing reference will be
to Excel 2003 (it might show in the list as Excel 11. It will look
something like 'MISSING: Microsoft 11.0 Object Library' Try unchecking
this box and ticking the box titled 'Microsoft 10.0 Object Library' or
something similiar. Then save and close the worksheet and open it
again.

What has happened is that somebody has created this sheet and written
code using the Microsoft 11 (2003) object library. When your version
of Excel tries to open this it looks for the library but can't find it,
and thats why you get the error.

I hope this goes some way towards solving your problem.

Matt