ExcelDeleteSheet

Structure

ExcelDeleteSheet(iSheet)

Type

Procedure

Description

This function deletes the indicated sheet.

Parameters: 1

iSheet = the index of the sheet to delete.

Example

Try

ExcelNewFile(3,"v2003")

ShowMessage(ExcelGetSheetCount) 'shows 3

ExcelDeleteSheet(1)

ShowMessage(ExcelGetSheetCount) 'shows 2

Except

ShowMessage(LastExceptionMessage)

End Try