Office Inside & Excel Sheet

1

Does anyone know:

  • how to get the Active Sheet Id, after the command MyExcel.SelectWorksheet(ExcelSheetName) ?
  • how to get list of existing Sheet names, after the comand MyExcel.OpenWorkbook(ExcelFileName) ?

Thank you, in advance

2

MyExcel1.CountWorksheets()

and

  MyExcel1.SelectWorksheet('', 2)
  MyExcel1.ActiveWorkSheet.oiGetProperty('Name',loc:ReturnValue)
  message('The Name of the selected worksheet is: ' & loc:ReturnValue)
3 Likes
3

It Works !! Thank you very much

1 Like