I have created a bot wherein I am using "MS Excel VBO - Open workbook" to open a particular excel workbook by giving the name of excel workbook with the path.
Eg: "C:\abc\xyz\Status Report - 28-08-2020.xlsx"
But instead of giving name, can I give instruction to bot to pick a latest sheet without giving it's name?
The reason being, bot is "saving as" the excel sheets and if I give name then it will pick particluar excel sheet. But everytime I run the bot then I want the latest excel sheet to be picked.