XL5: Run Time Error with QueryGetData or QueryGetDataDialog

• Microsoft Excel for Windows, versions 5.0

SYMPTOMS

In Microsoft Excel, you may receive the following error message if you run a macro that uses either the QueryGetData or the QueryGetDataDialog in Microsoft Excel version 5.0:

   Run-time error '1003'
   "Invalid Number of Arguments"

CAUSE

In Microsoft Excel 5.0, there was not an option to save your password with a query when using "Get External Data" from the Data menu. This feature was added in Microsoft Excel version 5.0c. Likewise, in Microsoft Excel version 5.0c, the XLQUERY.XLA add-in functions QueryGetData and QueryGetDataDialog acquired an additional argument called "KeepPassword" to determine whether or not the password should be saved with the query in your workbook.

MORE INFORMATION

The syntax for these functions in Microsoft Excel versions 5.0 is:

   QueryGetData(ConnectionStr, QueryText, KeepQueryDef, FieldNames,
       RowNumbers, Destination, Execute)

   QueryGetDataDialog(ConnectionStr, QueryText, KeepQueryDef, FieldNames,
       RowNumbers, Destination, Execute)

   QueryGetData(ConnectionStr, QueryText, KeepQueryDef, FieldNames,
       RowNumbers, Destination, Execute, KeepPassword)

   QueryGetDataDialog(ConnectionStr, QueryText, KeepQueryDef, FieldNames,
       RowNumbers, Destination, Execute, KeepPassword)

REFERENCES

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

   ARTICLE-ID: Q118754
   TITLE     : XL5: No Option to Save/Not Save Password with MSQuery Add-in