Connections Object (Excel)
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.
ActiveWorkbook.Connections.AddFromFile _
"C:\Documents and Settings\myComputer\My Documents\My Data Sources\Northwind 2007 Customers.odc"