Bot will start running the process at 7PM every day , once it is started it will create a folder like “InvalidOutput29122022”(Current day).After creating a folder the will perform web automation (Data scrapping) then it will create 4 excels inside the InvalidOutput29122022 folder"
After 12AM the bot will create another folder like “InvalidOutput30122022” and it will create the 4 excels output.
But I dont want bot to create another folder i.e InvalidOutput30122022, instead the bot should write the data inside the excels i.e first created folder InvalidOutput29122022.
Because Bots will run 12 hours every day i.e from 7PM to 7AM.
so after 12AM bots will create the another(next day folder). I just want bot to write all the excels inside a folder which was created @7PM at the time bot starts.
please do needful and give a logic even the bot created a new folder bot should write the output into excels which folder was created first.