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)
Syntax
'Declaration
<GuidAttribute("0002442B-0000-0000-C000-000000000046")> _
<InterfaceTypeAttribute()> _
Public Interface Parameters _
Inherits IEnumerable
'Usage
Dim instance As Parameters
[GuidAttribute("0002442B-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface Parameters : IEnumerable
Remarks
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.