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