Parameters Interface

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)

[GuidAttribute("0002442B-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface Parameters : IEnumerable

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.

Community Additions

ADD
Show:
© 2014 Microsoft