XL5 Err Msg: "Cannot Open Help..." XLODBC.XLA in Object Browser

• Microsoft Excel for Windows, version 5.0

SUMMARY

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.

CAUSE

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.

WORKAROUND

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.

3. In the Visual Basic Reference screen, choose Programming Language Summary.

4. In the Programming Language Summary screen, choose the S button.

5. Scroll down to the SQL function statements and select the function you need help with.

MORE INFORMATION

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.