Skip to main content

ExcelGetSheetCount

Structure​

ExcelGetSheetCount

Type​

Function

Description​

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

Parameters​

Example​

Try
  ExcelNewFile(3,"v2003")
  ShowMessage(ExcelGetSheetCount) 'shows 3
  ExcelDeleteSheet(1)
  ShowMessage(ExcelGetSheetCount) 'shows 2
Except
  ShowMessage(LastExceptionMessage)
End Try