Parameter.SetParam method (Excel)

Defines a parameter for the specified query table.

Syntax

expression.SetParam (Type, Value)

expression A variable that represents a Parameter object.

Parameters

Name	Required/Optional	Data type	Description
Type	Required	XlParameterType	One of the constants of XlParameterType, which specifies the parameter type.
Value	Required	Variant	The value of the specified parameter, as shown in the description of the Type argument.

Example

This example changes the SQL statement for query table one. The clause (city=?) indicates that the query is a parameter query, and the example sets the value of city to the constant Oakland.

Set qt = Sheets("sheet1").QueryTables(1) 
qt.Sql = "SELECT * FROM authors WHERE (city=?)" 
Set param1 = qt.Parameters.Add("City Parameter", _ 
 xlParamTypeVarChar) 
param1.SetParam xlConstant, "Oakland" 
qt.Refresh

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.