Create an integer variable to increment for example intCounter with a default value of 1
Do While intCounter < 3
Assign strFilename = "yamada " & DateTime.Now.ToString(“ddMM”) & “-” & intCounter.ToString & “.xlsx”
File exists activity. - check if strFilename exists
If it exists increment counter by assigning intCounter = intCounter+1
If it does not exist then break the loop
Hi @yangyq10
Since your process is time triggered, create an argument called in_runtime in Main.xaml. Now, in Orchestrator, set different value for different time triggers. For Eg: 8:30 am , set run time value as 1. Use the value while naming the downloaded file.
Thank you for the quick solution.
Can you help take a look if my below process is correct base on your advise?
On the other hand, after I assign intCounter=inCounter+1, how should I put this new filename into the download column I need to input?
@yangyq10 Each time the do while loops, a new value is assigned to strFilename until it finds a filename that does not exist and that filename is always stored to strFilename. So just use strFilename variable to type into the filename field of your save dialog box