I have troubles getting a robust selector for the Excel ‘Name box’, which is the little window where it says which cell is active (see picture). This is important to me as I am looking for a specific value (a string) in a big excel worksheet and if I find it - I need the row number of that specific value (ideally to save it as a variable for further usage).
My approach was to “Find Cell” and then copy the number out of the ‘Name Box’ but every time I open and close the excel workbook the selector becomes invalid. Although if I click indicate on screen again it creates exactly the same selector. Super frustrating.
Can anyone with a little bit more experience than me give me a hint on how to fix this issue??
Btw. yes, I also used UiExplorer without any luck:(
to be honest, I don’t exactly understand what you are saying.
I am always using the same excel with the same name and still, the selector becomes invalid after closing and reopening the excel file.
Like I mentioned earlier, I need to find the Number of the Row(126) which says “Hello”.
Therefore I was going to search for the word and then use get text or scrape data from the name box. But the selector for Name box doesn’t work…