AppEvents_Event.WorkbookRowsetComplete Event
The WorkbookRowsetCompleteevent occurs when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Event WorkbookRowsetComplete As AppEvents_WorkbookRowsetCompleteEventHandler
'Usage
Dim instance As AppEvents_Event
Dim handler As AppEvents_WorkbookRowsetCompleteEventHandler
AddHandler instance.WorkbookRowsetComplete, handler
event AppEvents_WorkbookRowsetCompleteEventHandler WorkbookRowsetComplete
Remarks
Because the recordset is created asynchronously, the event allows automation to determine when the action has been completed. Additionally, because the recordset is created on a separate sheet, the event needs to be on the workbook level.