The information in this article applies to:
SYMPTOMSMicrosoft Excel for Windows version 5.0c, may produce the following error message when calling a procedure that uses the xlquery.xla QueryGetData function:
CAUSE
Using the macro recorder, when you record clicking Get External Data on the
Data menu in Microsoft Excel for Windows version 5.0c, selecting a data
source in Microsoft Query, adding a table, performing a query and returning
your data to Microsoft Excel, the recorded code you end up with is a series
of application.run "QueryGetData" commands. This command is found in the
xlquery.xla add-in file which ships with Microsoft Excel.
RESOLUTION
To avoid the above error message do one of the following:
-or- -or- STATUSMicrosoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. MORE INFORMATIONThis behavior does not occur in Microsoft Excel version 5.0 for Windows or Microsoft Excel version 5.0 for Macintosh. REFERENCESFor more information about these commands, refer to Help in Microsoft Excel. Choose Contents from the Help menu, choose Programming With Visual Basic from the Contents screen and then choose search and type in SQL. This will take you to a listing of all of the SQL commands available in Microsoft Excels Visual Basic for Applications programming language. Additional query words: 1.00 MSQuery VB
Keywords : kbprg |
Last Reviewed: October 18, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |