Defines a parameter for the specified query table.
Syntax
expression.SetParam(Type, Value)
expression Required. An expression that returns a Parameter object.
Type Required Long. The parameter type. Can be one of the following XlParameterType constants.
| Constant | Description |
|---|---|
| xlConstant | Uses the value specified by the Value argument. |
| xlPrompt | Displays a dialog box that prompts the user for the value. The Value argument specifies the text shown in the dialog box. |
| xlRange | Uses the value of the cell in the upper-left corner of the range. The Value argument specifies a Range object. |
Value Required Variant. The value of the specified parameter, as shown in the description of the Type argument.