Open the downloaded excel file

Help
10

Try like this:
string[] yourVar = Directory.GetFiles(downloadsFolder).Where(Function(x) new FileInfo(x).CreationTime.Date = DateTime.Today.Date).ToArray()
Or if you want just the newest one:
string newestFile = Directory.GetFiles(downloadsFolder).Where(Function(x) new FileInfo(x).CreationTime.Date = DateTime.Today.Date).First()

Also note that for these kind of expressions it’s usually better to put them in an Assign activity instead of deafult value for a variable (as it get’s messy to debug/handle errors if f.e. location is unreachable and throws an IO exception).

3 Likes