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
추가된 버전: Excel 2007
Syntax
식 .Connections
식 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