Share via


Parameter Members

Include Protected Members
Include Inherited Members

Represents a single parameter used in a parameter query. The Parameter object is a member of the Parameters collection.

The Parameter type exposes the following members.

Properties

  Name Description
Public property Application Returns an Application object that represents the Microsoft Excel application. Read-only.
Public property Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
Public property DataType Returns or sets the data type of the specified query parameter. Read/write XlParameterDataType.
Public property Name Returns or sets the name of the object. Read/write String.
Public property Parent Returns the parent object for the specified object. Read-only.
Public property PromptString Returns the phrase that prompts the user for a parameter value in a parameter query. Read-only String.
Public property RefreshOnChange True if the specified query table is refreshed whenever you change the parameter value of a parameter query. Read/write Boolean.
Public property SourceRange Returns a Range object that represents the cell that contains the value of the specified query parameter. Read-only.
Public property Type Returns or sets the parameter type. Read-only XlParameterType.
Public property Value The parameter value. For more information, see the Parameter object. Read-only Object.

Top

Methods

  Name Description
Public method SetParam Defines a parameter for the specified query table.

Top

See Also

Reference

Parameter Interface

Microsoft.Office.Interop.Excel Namespace