I am opening an Excel workbook. Each time that workbook changes based on the number of attempts to open.
In order to cope with the name change, I located the needed items using this query:
Code: Select all
workbook[@name>='Prelim']/table/row[@index='10']/cell[@address='E10']
The 'Prelim' name changes. Normally the Spy captures this name for the workbook:
Code: Select all
workbook[@name='PrelimByMonthReport 2 .xls']/table/row[@index='10']/cell[@address='L10']
However I am having trouble finding the required cells using the first >= query. Each time the workbook does open with the title Prelim. Do you have any suggestions on a modified query or something more accurate than >='Prelim'. Thank you in advance.
I also tried making a folder in the repository, setting the base, and adding any child elements. The base is this:
I need this to accept any workbook OR any workbook starting with that prefix and allowing any uppercase/lowercase characters following the Prelim.