Workbook.RowsetComplete Event (Excel)

The event is raised 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 .RowsetComplete(Description, Sheet, Success)

expression A variable that represents a Workbook object.

Parameters

Name

Required/Optional

Data Type

Description

Description

Required

String

A brief description of the event.

Sheet

Required

String

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.

See Also

Concepts

Workbook Object

Workbook Object Members