Parameter Object

Remarks

The Parameter object is a member of the Parameters collection.

Example

Use Parameters(), where is the index number of the parameter, to return a single Parameterobject. The following example modifies the prompt string for parameter one.

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

See also:

• Excel Object Model Reference
• Parameter Object Members