Item Method (Parameters Collection) Example

This example modifies the parameter prompt string.

With Worksheets(1).QueryTables(1).Parameters.Item(1)
    .SetParam xlPrompt, "Please " & .PromptString
End With