Skip to main content

ExcelRenameCurrentSheet

Structure​

ExcelRenameCurrentSheet(sName)

Type​

Procedure

Description​

This function renames the current sheet to the indicated name.

Parameters​

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