Parameters interface

Office 2013 and later

A collection of Parameter objects for the specified query table. Each Parameter object represents a single query parameter. Every query table contains a Parameters collection, but the collection is empty unless the query table is using a parameter query.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

Use the Parameters property to return the Parameters collection.

Use the Add method to create a new parameter for a query table.

You cannot use the Add method on a URL connection query table. For URL connection query tables, Microsoft Excel creates the parameters based on the Connection and PostText properties.

Show: