ListWorkSheets

Syntax

XLS.ListWorkSheets arrSheets()

Description

This method fills an array with loaded Worksheets in the active workbook in the current Excel session.

Parameter	Description
arrSheets()	String array, zero-based. Holds an array of worksheet names in the active workbook.

See Also

ListWorkBooks, WorkSheetCount

Example

Sub Main

Dim mySheets() As String

Dim x As Integer

If Not XLS.AppInit() Then Exit Sub

XLS.AppVisible = True

XLS.AddWorkBook

XLS.AddWorkSheet "Test1"

XLS.AddWorkSheet "Test2"

XLS.ListWorkSheets mySheets()

For x = 0 To UBound(mySheets)

Debug.Print mySheets(x) 'Test2, Test1, Blad1

Next x

XLS.AppClose

End Sub