WorkbookEvents_Event.PivotTableCloseConnection EventĀ 

Occurs after a PivotTable report closes the connection to its data source.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Usage

WithEvents workbookEvents_Event1 As WorkbookEvents_Event
Function workbookEvents_Event1_PivotTableCloseConnection(Target As PivotTable) As Void
    Handles workbookEvents_Event1.PivotTableCloseConnection
End Function

Syntax

Event PivotTableCloseConnection As WorkbookEvents_PivotTableCloseConnectionEventHandler
event WorkbookEvents_PivotTableCloseConnectionEventHandler PivotTableCloseConnection;
event WorkbookEvents_PivotTableCloseConnectionEventHandler^ PivotTableCloseConnection;
 void add_PivotTableCloseConnection(WorkbookEvents_PivotTableCloseConnectionEventHandler handler);
 void remove_PivotTableCloseConnection(WorkbookEvents_PivotTableCloseConnectionEventHandler handler);
In JScript, you can handle the events defined by a class, but you cannot define your own.

Platforms

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

See Also

Reference

WorkbookEvents_Event Interface
Microsoft.Office.Interop.Excel Namespace

Other Resources

WorkbookEvents_Event Members