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.ListWorkBooks myBooks()

For x = 0 To UBound(myBooks)

Debug.Print myBooks(x) 'Map1, Map2

Next x

XLS.AppClose

End Sub