The WorkbookRowsetComplete event occurs when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable.
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.