ID: Q110500
5.00 WINDOWS kberrmsg
The information in this article applies to:
In Microsoft Excel, if you use the Object Browser to view objects and functions in the XLODBC.XLA add-in, you receive the following error message if you choose the Help On Procedure Or Property button to get help on a selected SQL function:
Cannot open Help file.
There is no separate help file for the XLODBC add-in. The error message appears because the Help engine is looking for a help file in EXCEL\LIBRARY\MSQUERY and there is no help file in this directory.
You can get information on the SQL functions provided by the XLODBC add-in in the Visual Basic Reference by doing the following:
1. In Microsoft Excel, from the Help menu, choose Contents.
2. In the Microsoft Excel Help Contents screen, choose Programming With
Visual Basic.
Summary.
5. Scroll down to the SQL function statements and select the function you
need help with.
The Object Browser dialog box lists all procedures, objects, methods, and properties that are available for use in the active workbook or that are currently loaded in Microsoft Excel. You can get help on a specific method or property by selecting that item from the Methods/Properties list and clicking the Help On Procedure Or Property button (the question mark button). If there is no help available for the selected item, the Help On Procedure Or Property button is unavailable. The problem described above is an exception to this behavior.
If the XLODBC.XLA library is not listed in the Object Browser, you have not installed the Microsoft Excel ODBC add-in (XLODBC.XLA). For more information, see "Installing Add-ins" in Chapter 37 of the "User's Guide," or see Installing or removing an add-in in Help.
KBCategory: kberrmsg KBSubcategory: xlquery kbtool
Additional reference words: 5.00 msquery err msg
Keywords : kbtool xlquery
Version : 5.00
Platform : WINDOWSLast Reviewed: September 15, 1996