Skip to main content

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.

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.

 

Reply


Terms & ConditionsCookie settings