what i understand is that there is link you want to open, in which some part has date in it. And that date is taken from excel.
You can read the excel and use a for each data row activity, in that, you can simply use open browser (if you want to have the new session every time) or you can use Navigate to (if you want to stay on the same page and load the next transaction). In the address field just enter the (URL part which is static)+ row(“date”).tostring
Hope this helps, else you may give us more information and if possible, a screenshot. that would help us to help you
When I take the word SEARCH IN PAGE and click on it is it like you are looking for a text in the page and click it
Did we try with CLICK TEXT activity where we can pass the dynamic value as input from excel and it will click the text in web page
Ensure that the click text activity is placed inside ATTACH BROWSER activity
As in the example i downloaded from the forum and added a vaible from excel, Example.xaml (17.7 KB)
instead of Click Image “Ask in Your Language”
i want the text to be the variable string.
as i will have a lot of excel files with different variables and i want to search each excel from the specific cell “C2” to find it in chrome and press it.
i cannot do this with image or indication on screen
Search in chrome for the text is fine
Once we got the text it can be assigned to a variable and can be sent to CLICK TEXT activity
Did we try that option @neoklis.neokleous
due to sensitive information i cannot send you my project but for example,
i want to go to https://www.java.com/en/download/manual.jsp and search for “Windows Offline (64-bit)” which i get it from excel and it is in Cell C2.
i add it as variable string and i want to search the java page, find it and click it but not as image because the next person, Cell C3 may have “Mac OS X” to be clicked.
i cannot make the CLICK TEXT activity to work.
Why not
With CLICK TEXT activity we can click on text along with ctrl key so that new tab will be opened for that and this page remains there so that next “Mac OS X” will be clicked with ctrl key
Ctrl key can be enabled in a click activity with Key modifiers property
KeyModifiers - Enables you to add a key modifier. The following options are available: Alt, Ctrl, Shift, Win.