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
| |
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
|