Parameter Parameter Parameter Interface

Definition

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

public interface class Parameter
[System.Runtime.InteropServices.Guid("0002442A-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Parameter
Public Interface Parameter
Attributes

Properties

Application Application Application

Returns an Application object that represents the Microsoft Excel application. Read-only.

Creator Creator 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.

DataType DataType DataType

Returns or sets the data type of the specified query parameter. Read/write XlParameterDataType.

Name Name Name

Returns or sets the name of the object. Read/write String.

Parent Parent Parent

Returns the parent object for the specified object. Read-only.

PromptString PromptString PromptString

Returns the phrase that prompts the user for a parameter value in a parameter query. Read-only String.

RefreshOnChange RefreshOnChange RefreshOnChange

True if the specified query table is refreshed whenever you change the parameter value of a parameter query. Read/write Boolean.

SourceRange SourceRange SourceRange

Returns a Range object that represents the cell that contains the value of the specified query parameter. Read-only.

Type Type Type

Returns or sets the parameter type. Read-only XlParameterType.

Value Value Value

The parameter value. For more information, see the Parameter object. Read-only Object.

Methods

SetParam(XlParameterType, Object) SetParam(XlParameterType, Object) SetParam(XlParameterType, Object)

Defines a parameter for the specified query table.

Applies to