Connections Object (Excel)

A collection of Connection objects for the specified workbook.

Version Added: Excel 2007

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"

Community Additions

ADD
Show:
© 2014 Microsoft