Hi Walter,
Excel doesn't expose GUI objects for individual cells inside the workbooks — you'll need to use Excel Automation API (the
Excel.Application scripting object) to access their data.
For example, to get the "calculated" text of the C1 cell in an active workbook and sheet, you can use the following expression:
Sys.OleObject("Excel.Application").ActiveWorkbook.ActiveSheet.Range("C1").Text
I'm afraid, you can't select scripting objects in the checkpoint wizard, so you need to add such a checkpoint to your test manually. In VBScript, for example, the checkpoint for the C1 cell would look like this:
