XLS Object

WorkSheetCount

 
Syntax
 
Result = XLS.WorkSheetCount[()]
 
Description
Returns the number of worksheets in the active workbook of the current Excel session.
 
If there is no active Excel session, this function will return 0 (zero).
 
See Also
WorkBookCount
Example
 
Sub Main
 
   If Not XLS.AppInit() Then Exit Sub
 
   XLS.AppVisible = True
 
   XLS.AddWorkBook
   XLS.AddWorkSheet "tweede"
   XLS.AddWorkSheet "derde"
 
   Debug.Print XLS.WorkSheetCount   '3
 
   XLS.AppClose
 
End Sub