ExcelGetSheetCount

Structure

ExcelGetSheetCount

Type

Function

Description

This function returns the number of sheets in the Excel file as an integer.

Parameters: 0

Example

Try

ExcelNewFile(3,"v2003")

ShowMessage(ExcelGetSheetCount) 'shows 3

ExcelDeleteSheet(1)

ShowMessage(ExcelGetSheetCount) 'shows 2

Except

ShowMessage(LastExceptionMessage)

End Try