Export (0) Print
Expand All

Parameter Members (Excel)

Represents a single parameter used in a parameter query.

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.

Show:
© 2014 Microsoft