Share via

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

참고 항목

개념

Workbook Object

Workbook Object Members