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