ExcelGetSheetByName

Structure

ExcelGetSheetByName(sName)

Type

Procedure

Description

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

Parameters: 1

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