XLS Object

AddWorkSheet

 
Syntax
 
XLS.AddWorkSheet SheetName
 
Description
Adds a new worksheet to the active workbook
 
If there is no active Excel session, this sub will automatically initialise a new Excel session, using the AppInit function.
 
The newly created worksheet will automatically be set as active.
 
Parameter
Description
SheetName
The name of the new worksheet. Required
 
 
See Also
DeleteWorkSheet, WorkSheetCount
Example
 
Sub Main
 
Dim strName As String
 
   XLS.AppInit
 
   strName = XLS.AddWorkBook()
 
   XLS.AddWorkSheet "MijnBlad"
 
   Debug.Print XLS.ActiveWorkBook		'Map1
   Debug.Print XLS.ActiveSheet 		'MijnBlad
 
   XLS.CloseWorkBook
   XLS.AppClose
 
End Sub