This topic has not yet been rated - Rate this topic

Application.WorkbookRowsetComplete Event

Office 2007

The WorkbookRowsetComplete event occurs when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable.

Version Information
Version Added: Excel 2007

Syntax

expression.WorkbookRowsetComplete(Wb, Description, Sheet, Success)

expression A variable that represents an Application object.

Parameters

Name	Required/Optional	Data Type	Description
Wb	Required	Workbook	The workbook for which the event occurs.
Description	Required	String	A brief description of the event.
Sheet	Required	String	The worksheet on which the recordset is created.
Success	Required	Boolean	Contains a Boolean value to indicate success or failure.

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.