Making read range activitiy more dynamic

Help Studio
, ,
1

Is the a way to make the browser file more dynamic, for example I have a dated case where it is dated daily is there a way to make the activity choose the most recent file in the folder?

E.g. Casestudy-27072022.xls was picked up today and then Casestudy-28072022.xls was picked up tomorrow?

2

Hi @duaine.bonsu

You could try this dynamic file name

image

"Casestudy-"+Now.ToString("ddMMyyyy")+".xls"

3

Hey!

Yes, we can do that

We can give the system date to pick the today’s date file

Assign Folderpath ="Desktop\InputFolder\"

Assign ArrFiles = (FolderPath,"Casestudy-"+Now.ToString("ddMMyyyy")+".xls")

Take one for each row and pass the ArrFiles

This will give you the currentDate File

Regards,
NaNi

4

Perfect, this worked well for me :+1:

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.