This documentation is archived and is not being maintained.

XlParameterType Enumeration

Office 2007
Specifies how to determine the value of the parameter for the specified query table.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlConstant1Uses the value specified by the Value argument.
xlPrompt0Displays a dialog box that prompts the user for the value. The Value argument specifies the text shown in the dialog box.
xlRange2Uses the value of the cell in the upper-left corner of the range. The Value argument specifies a Range object.


Show: