Workbook.Connections Property (Excel)
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 2007
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.
ActiveWorkbook.Connections(1).ODBCConnection.Refresh
ActiveWorkbook.Connections(1).OLEDBConnection.Refresh