I wonder if you could help me with the application here in attachment. My Robot is supposed to
1- sort the folders by name,
2- pick the first one (which is the name with the most recent date),
3- find that specific Excel file inside this folder whose name contains a keyword (e.g. Industry, Banking etc)
4- do operations with this excel.
Well, I managed so far to complete point 1 and end up with an array of folder names sorted by name. 1. How can I now select the first folder in this array?
2. How can I search the Excel file in this folder whose name contains my keyword and store the full path of such selected Excel file in a variable for subsequent use? I tried with an if activity but it does not really work.
Thanks a lot
GennaroSales Meetings.zip (20.4 KB)