How to retrieve a dynamic excel file from my desktop based on the current date

  • 6 November 2023
  • 1 reply

Badge +1

Hello, I am creating a bot that runs a report everyday (except the weekends) before 7am. So, everyday it’s a new excel sheet and currently the bot is retrieving a specific excel sheet. The problem is how do I get the bot to retrieve the current excel sheet and not yesterdays excel sheet.

So I could change the file path everyday but then I could just do this manually which defeats the purpose of automating this process.

1 reply

Badge +1

Here is my last step I’ve included an attachment using desktop file with the file path. This works but it needs to retrieve the most current excel file. In the image you can see RN0596 this number increments by one everyday. Is there a way I can use this so the bot can retrieve the most recent excel file.