EXCEL 97 MACROS fail to work in EXCEL 2003

[Gib Gibson]

I have the same problem that was posted by Jason earlier. See below:

"I have written and run many macros in Excel 97 that when I try to run them in
Excel 2003 I get an error message, "Can't find project or library".
My original system was a Window 2000 with Office 97 installed. The new
system is Windows XP with Office 2003.
I am not using any special instuctions in the macros. One of the
instructions that it does not under stand now is 'Chr()'.
I believe that I am missing a library file or OBL file.
I did notice that under the references that the 'ActiveEX type library' had
'MISSING' before it. I don't know if this is the problem or where to find
this file."

He reported that he was able to correct the problem by unchecking the
'ActiveEX type library' as suggested by a responding post. I find no
'ActiveEX type library' listed in the references and no item labeled "MISSING"

Many manhours have gone into this application and I would hate to have to
start over. Any help would be greatly appreciated.

 

[George Nicholson]

In the VBE, what *is* checked under Tools>References?

- AFAIK, (Excel 2003) minimum is "Visual Basic for Applications" and
"Microsoft Excel 11.0 Object Library". I think "OLE Automation" is checked
by default, but I generally don't find it necessary. However, that may just
be anecdotal.
- If you have any User Forms you'd need "Microsoft Forms 2.0 Object Library"
- If you have any code that references Toolbars, Office Assistants, etc.,
you'd need "Microsoft Office 11.0 Object Library"
- Do you have any code that references outside data sources? Then you'd
probably need either "Microsoft DAO 3.6 Object Library" or "Microsoft Active
X Data Objects 2.8 Library"
- Do you have any code that automates other Office applications? Then you
probably need a reference to that Object libary also.

As you may know, getting an error on Chr(), or any other standard VBA
function, unfortunately provides no clue as to *what* reference is missing,
only that a reference *is* missing.

If this doesn't help, more information about what references you do have
checked, what your app does (what it interacts with), and (maybe) specifics
on what errors you are seeing might help us get you going again.

HTH,

 

[Gib Gibson]

Notes on the project:
* Opens a custom tool bar file is opened and closes it when file is closed.
* Contains forms
* Has links to other excel spreadsheet.

The first error message that appears is: An error occurred while loading
'sheet 20'. Do you want to continue loading the project?

After selecting "yes" I get " Invalid procedure call or arguement."

I checked all the resources you suggested, but was unable to save the
document.

I analyzed Sheet 20 and could not see anything that I felt was causing the
problem. I decided to blow it away and see what happened.

File now loads without the problem.

Still a mystery since another worksheet in the workbook has all the same
procedures as far as I can tell.

Thanks for responding to my post. If I find the problem I will let yo know
if you like.