Connections object (Excel)

A collection of WorkbookConnection objects for the specified workbook.

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"

Methods

• Add
• AddFromFile
• Item

Properties

• Application
• Count
• Creator
• Parent

See also

• Excel Object Model Reference

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.