ExcelRenameCurrentSheet

Structure

ExcelRenameCurrentSheet(sName)

Type

Procedure

Description

This function renames the current sheet to the indicated name.

Parameters: 1

sName = the new name for the sheet.

Example

Try

ExcelNewFile(3,"v2003")

ShowMessage(ExcelGetSheetCount) 'shows 3

ExcelGetSheetByIndex(1)

ShowMessage(ExcelGetCurrentSheetName) 'shows "Sheet1"

ExcelRenameCurrentSheet("New Name")

ShowMessage(ExcelGetCurrentSheetName) 'shows "New Name"

Except

ShowMessage(LastExceptionMessage)

End Try