Method: Remove for Worksheets

Method: Remove for Worksheets

Deletes a worksheet in an Excel workbook.

Object.Remove(NameOrIndex)

The following example creates an Excel workbook, checks whether the Data worksheet exists, and deletes it. Refer to the help page Worksheets for detailed examples:

Dim oMyWorkbook, oMyWorkSheet
Set oMyWorkbook = CreateExcelWorkbook()
If oMyWorkbook.Worksheets.Exists("Data") Then
  Call  oMyWorkbook.Worksheets.Remove("Data")
End If

oMyWorkbook = dd.CreateExcelWorkbook() 
if oMyWorkbook.Worksheets.Exists("Data") : 
     oMyWorkbook.Worksheets.Remove("Data")