Workbook.Connections Property

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.

  ActiveWorkbook.Connections(1).ODBCConnection.Refresh
ActiveWorkbook.Connections(1).OLEDBConnection.Refresh

See Also

• Workbook Object
• Workbook Object Members