This documentation is archived and is not being maintained.

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

Dim xlParameterType1 As XlParameterType = XlParameterType.xlConstant

public enum XlParameterType
public enum XlParameterType
public enum XlParameterType

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

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms