Workbook.Connections Property
The Connections property establishes a connection between the workbook and an ODBC or an OLEDB data source and refreshes the data without prompting the user. Read-only.
Version Information
Version Added: Excel
Syntax
expression.Connections
expression A variable that represents a Workbook object.
Example
The following exmaple rereshed the OBDC and OLEDB connections of the active workbook.
| Visual Basic for Applications |
|---|
|