XlParameterType enumeration (Microsoft.Office.Interop.Excel)

XlParameterType enumeration

Office 2013 and later

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)

Syntax

No code example is currently available or this language may not be supported.

	Member name	Description
	xlPrompt	Displays a dialog box that prompts the user for the value. The *Value* argument specifies the text shown in the dialog box.
	xlConstant	Uses the value specified by the *Value* argument.
	xlRange	Uses the value of the cell in the upper-left corner of the range. The *Value* argument specifies a Range object.