Skip to main content

ExcelGetSheetByName

Structure​

ExcelGetSheetByName(sName)

Type​

Procedure

Description​

This function switches the current sheet to the one matching the name.

Parameters​

sName = the name of the sheet to switch to

Example​

Try
  ExcelNewFile(3,"v2003")
  ShowMessage(ExcelGetSheetCount) 'shows 3
  ExcelGetSheetByName("Sheet1")
  ShowMessage(ExcelGetCurrentSheetName) 'shows "Sheet1"
Except
  ShowMessage(LastExceptionMessage)
End Try