DeleteWorkSheet

Syntax

XLS.DeleteWorkSheet [shName]

Description

This method remove a worksheet from the active workbook.

Parameter	Description
shName	String, optional. The name of the worksheet that needs to be removed. If omitted or when a zero-length string is specified, the active worksheet is closed.

See Also

AddWorkSheet, WorkSheetCount

Example

Sub Main
 
Dim strName As String
 
   If Not XLS.AppInit() Then Exit Sub
 
   XLS.AppVisible = True
 
   strName = XLS.AddWorkBook()
 
   XLS.AddWorkSheet "MijnBlad"
 
   XLS.DeleteWorkSheet "Blad1"
 
   XLS.CloseWorkBook
 
   XLS.AppClose
 
End Sub