Contains information about a query parameter.
Element |
Description |
ExcelType |
Specifies the data type of a query parameter. |
Formula |
Contains the formula corresponding to a defined name, a range in another workbook, a query parameter, or a PivotTable field, formula, or item. |
Name |
Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range. |
ParameterType |
Specifies a parameter type. |
ParameterValue |
Specifies the value of a query parameter. |
PromptString |
Contains the message displayed when the user is prompted for a query parameter. |
NonDefaultName |
Specifies whether a query parameter has a user-defined name. |
SQLType |
Specifies the SQL data type of a query parameter or PivotTable field. |
RefreshOnChange |
Specifies whether the data from an external data source is refreshed when a cell used to calculate a parameter formula is changed. |
None.