before starting the Bot i have to make sure it opens the right file. So my problem is, that everytime i see a solution here on the forum, it only gets with assign activites, but i need the right workbook path at the beginning of the excel application scope. With that, i have to make sure to open only 1 file.
For example: today´s file is : “Prio Compare_summary_1007” and i need to open the file from last week so it would have to be “Prio Compare_summary_0307”. As you can see the last numbers are in the following format: “ddmm”, so first the day and then the month.
So opening of the file as per the date ending in the filename.
In this the date will be taken as a input from user or der are some rules that should follow the sequence of reading the file as per date ??
thanks for the reply @Pratik_Wavhal
no there is no input from the user, the Bot should automatically select the file from last week (exact 7 days before).
@mcLauge use the following expression in the excel application scope path :
“Prio Compare_summary_”+Date.UtcNow.AddDays(-7).ToString(“ddMM”)+“.xlsx” Sequence8.xaml (3.9 KB)