Workbook Connection Object

The WorkbookConnection object manages all external data connections in a workbook. Each time a QueryTable, ListObject, or PivotCache that points to external data is created, a new instance of a WorkbookConnection object is created. You can also create a standalone WorkbookConnection object, one that is not associated with any external data container. You can create a new WorkbookConnection object using the Add or AddFromFile methods of the Workbook.Connections collection. See Chapter 21 for examples of how to use the WorkbookConnection object.

0 -1


Post a comment