Part of the problem here is that we are doing this over
the phone and the user is not being clear. When the
routine fails, it pulls up the visual basic editor. At
that point, when he goes to tools/references, the
references is greyed out. I had him close the workbook
completely and then go back to the references and tell me
what he saw. Are you saying that if the workbook was not
open then he could see a reference check list that looks
fine? Shouldn't it be the same regardless of what file is
open?


-----Original Message-----
Suspect he might not have your workbook as the active
project when looking
at tools references. Your workbook must be selected in
the project explorer
when he goes to tools references. He should look after
he experiences the
error (might have to hit reset). Then he should see a
reference marked as
MISSING.

Excel automatically uses the higher version of the
libraries.

--
Regards,
Tom Ogilvy

"ExcelMonkey" wrote
in message
...
I have a client that cannot open one of our models.
Sounds like the file is crashing right off opening. He
is
getting a comple error that says "cannot find project or
library" This client has run these type of spreadsheets
before. He is using Excel 2003. We are using Excel
2000. The model opens up properly on my machine.

In Excel the client has his add-ins installed.
Analysis Toolpack
Analysis Toolpack VBA

In VBA his tools/references have:
Visual Basic for Applications
Microsoft Excel 11.0 Library
OLE Microsoft Office 11.0 LibraryAutomation
Microsoft Forms 2.0 Object Library

The only difference that I can see if that we are using
the 9.0 library for Excel and Office.

Why would a later version of Excel not run this file?


.