ListWorkBooks

Syntax

XLS.ListWorkBooks arrBooks()

Description

This method fills an array with loaded workbooks in the current Excel session.

Parameter	Description
arrBooks()	String array, zero-based. Holds an array of workbook names.

See Also

ListWorkSheets, WorkBookCount

Example

Sub Main
 
Dim myBooks() As String
Dim x As Integer
 
   If Not XLS.AppInit() Then Exit Sub
 
   XLS.AppVisible = True
 
   XLS.AddWorkBook
   XLS.AddWorkBook
 
   XLS.ListWorkBooks myBooks()
 
   For x = 0 To UBound(myBooks)
      Debug.Print myBooks(x)   'Map1, Map2
   Next x
 
   XLS.AppClose
 
End Sub