How to pick latest excel sheet from a folder?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-09-20 10:33 AM
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
------------------------------
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-09-20 05:47 PM
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
America/Santiago
------------------------------
Daniel Sanhueza
RPA Professional Developer
Deloitte
RPA Professional Developer
Deloitte

- « Previous
-
- 1
- 2
- Next »