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.