This documentation is archived and is not being maintained.

Workbook.Connections Property

Office 2007
The Connections property returns the collection of data connections in the workbook. Read-only.

Version Information
 Version Added:  Excel 2007

Syntax

expression.Connections

expression   A variable that represents a Workbook object.

Example

The following example rereshes the OBDC and OLEDB connections of the active workbook.

Visual Basic for Applications
ActiveWorkbook.Connections(1).ODBCConnection.Refresh
ActiveWorkbook.Connections(1).OLEDBConnection.Refresh



Show: