This documentation is archived and is not being maintained.

Connections Object

Office 2007
A collection of Connection objects for the specified workbook.

Version Information
 Version Added:  Excel 2007

The following example shows how to add a connection to a workbook from an existing file.

Visual Basic for Applications
ActiveWorkbook.Connections.AddFromFile _
        "C:\Documents and Settings\rodchis\My Documents\My Data Sources\Northwind 2007 Customers.odc"