This documentation is archived and is not being maintained.

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)

'Usage
Public Class arametersImplementation
	Implements Parameters
End Class
Dim arametersImplementation1 As New arametersImplementation()

'Declaration
Public Interface Parameters
public interface Parameters
public interface Parameters

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.


Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Show: