XLS Object

WorkBookCount

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