Connections Object

  • Article
Excel Developer Reference

A collection of Connection objects for the specified workbook.

Version Information
 Version Added:  Excel 2007

Example
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"

See Also