XlParameterType Enumeration
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

XlParameterType Enumeration

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

public enum XlParameterType

Member nameDescription
xlPromptDisplays a dialog box that prompts the user for the value. The Value argument specifies the text shown in the dialog box.
xlConstantUses the value specified by the Value argument.
xlRangeUses the value of the cell in the upper-left corner of the range. The Value argument specifies a Range object.
© 2016 Microsoft