How can I read a file that keeps changing its name and it does not change regularly

I want to read a excel file,but it change its name when i download each time,how can i read it?

can you show an example file name? and which folder does it download to?

@jack.chan ,Ok,it sames like “Chan-198725543.xlsx”,and the “198725543” will changed,and no regularity.And I will download it in a floder which i created.And it was a zipped file when i download it first time and i use the Extract/Unzip Files Activity put into the floder.

can you try this

latestFile = Directory.GetFiles(folderPath,"*.xlsx").OrderByDescending(Function(d) New FileInfo(d).CreationTime)(0)

1 Like

@jack.chan ,Thanks,I tried it just now,it was useful!Thank u so much!

1 Like

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