cancel
Showing results for 
Search instead for 
Did you mean: 

How to pick latest excel sheet from a folder?

SwatiAgrawal
Level 5
Hi Everyone,

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.

Please suggest and help.


------------------------------
SWA
------------------------------
10 REPLIES 10

Use the Path of the file, and work with it using the MS Excel VBO 😄

------------------------------
Daniel Sanhueza
RPA Professional Developer
Deloitte
America/Santiago
------------------------------
Daniel Sanhueza
RPA Professional Developer
Deloitte