Parameter Members (Excel)

Represents a single parameter used in a parameter query.

Methods

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

Name	Description
Application	When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
DataType	Returns or sets a XlParameterDataType value that represents the data type of the specified query parameter.
Name	Returns or sets a String value representing the name of the object.
Parent	Returns the parent object for the specified object. Read-only.
PromptString	Returns the phrase that prompts the user for a parameter value in a parameter query. Read-only String.
RefreshOnChange	True if the specified query table is refreshed whenever you change the parameter value of a parameter query. Read/write Boolean.
SourceRange	Returns a Range object that represents the cell that contains the value of the specified query parameter. Read-only.
Type	Returns a XlParameterType value that represents the parameter type.
Value	Returns a Variant value that represents the parameter value.