WorksheetList Event
Fired once for each worksheet entry retrieved.
Syntax
Sub gspreadsheetscontrol_WorksheetList(Id As String, ETag As String, DateUpdated As String, Title As String, RowCount As Integer, ColumnCount As Integer)Remarks
The WorksheetList event is fired for each worksheet entry retrieved after a QueryWorksheets call.
Id contains the ID value for the current worksheet.
ETag contains the ETag value for the current worksheet.
DateUpdated contains the date and time that the current worksheet was last updated. The format of the date will depend on the DateFormat you are currently using. Unless otherwise specified, the default format used is "yyyy-MM-ddTHH:mm:ss.fffZ" (e.g. 2011-04-04T18:44:20.000Z).
Title contains the title of the current worksheet.
RowCount contains the number of rows in the current worksheet.
ColumnCount contains the number of columns in the current worksheet.