Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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