Connections object (Excel)
A collection of WorkbookConnection objects for the specified workbook.
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"
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.