Parameter Object [Excel 2003 VBA Language Reference]
Parameters Parameter Range |
Represents a single parameter used in a parameter query. The Parameter object is a member of the Parameters collection.
Using the Parameter Object
Use Parameters(index), where index is the index number of the parameter, to return a single Parameter object. The following example modifies the prompt string for parameter one.
With Worksheets(1).QueryTables(1).Parameters(1)
.SetParam xlPrompt, "Please " & .PromptString
End With
Properties | Application Property | Creator Property | DataType Property | Name Property | Parent Property | PromptString Property | RefreshOnChange Property | SourceRange Property | Type Property | Value Property
Methods | SetParam Method
Parent Objects
Child Objects | Range Object