Workbook.Connections Property

  • Article
Excel Developer Reference

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

See Also