Office development
Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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



Community Additions

Show:
© 2016 Microsoft