Share via

Parameter Object

  • Article
Worksheets (Worksheet)
Aa218937.parchild(en-us,office.10).gifQueryTables (QueryTable)
Aa218937.space(en-us,office.10).gifAa218937.parchild(en-us,office.10).gifParameters (Parameter)

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