Article ID: 151544
Article Last Modified on 10/10/2006
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
This article was previously published under Q151544
SYMPTOMS
When you run a procedure from a module that contains a reference to the Xlodbc.xla file, you may receive the following error message:
In Microsoft Excel 97, you may receive this error as soon as you open the workbook that contains a reference to Xlodbc.xla.
MORE INFORMATION
This error occurs when all of the following are true:
- Both Microsoft Excel version 5.0 and Microsoft Excel version 7.0 or 97 are installed in separate folders on the same computer. -and-
- A file created in Microsoft Excel version 5.0 contains a Visual Basic for Applications procedure calling SQL functions from a module with a reference to the Microsoft Excel version 5.0 file Xlodbc.xla. -and-
- The procedure is being run from Microsoft Excel version 7.0 or Microsoft Excel 97 on the same computer where Microsoft Excel 5.0 is installed.
The error message,
may also occur if a procedure with a reference to Xlodbc.xla created in Microsoft Excel version 7.0 or 97 is run from Microsoft Excel version 5.0 on the same computer.
CAUSE
When you establish a reference to another workbook or library, Microsoft Excel hard-codes the path of the file when the reference is established. The error occurs because the path to the Xlodbc.xla file is still valid, and Microsoft Excel attempts to open the incorrect Xlodbc.xla file.
The error does not occur if only one version of Microsoft Excel is installed on the computer. Instead, if the file cannot be found, you may receive the following error message:
See articles referenced later in this article for more information about this error.
RESOLUTION
Microsoft Excel 7.0
With your module sheet active, click References on the Tools menu, click to clear the current reference, and use the Browse option to establish a new reference to the correct Xlodbc.xla file. After establishing the correct reference, save and close the file, and then restart Microsoft Excel.
Microsoft Excel 97
Press ALT+F11 to activate Visual Basic Editor. Click References on the Tools menu, click to clear the current reference, and use the Browse option to establish a new reference to the correct Xlodbc.xla file. Click Close and Return to Microsoft Excel on the File menu. Save and close the file, and then restart Microsoft Excel. For additional information, please see the following articles in the Microsoft Knowledge Base:
124277 XL5 Err Msg: "Can't Find Project or Library" Running Macro
131298 XL5 How to Avoid the Error "Can't Find Project or Library"
REFERENCES
For more information about calling procedures in Microsoft Excel 97, from the Visual Basic Editor, click the Office Assistant, type "calling procedures," click Search, and then click to view "Calling Sub and Function Procedures."
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If the Assistant is not able to answer your query, please see the following article in the Microsoft Knowledge Base:
176476 OFF: Office Assistant Not Answering Visual Basic Questions
"Visual Basic User's Guide," version 5.0, chapter 4, "Organizing Procedures and Modules in Workbooks"
For more information about calling procedures in other workbooks, click Microsoft Excel Help Topics on the Help Menu, click the Index tab and type:
Calling procedures
Additional query words: 5.00 5.00a 5.00c 7.00a 8.00 97 Attempt to register Xlodbc32 dll failed XLODBC XL
Keywords: kberrmsg kbprb kbprogramming KB151544