Trying to find the most recent file with the following code:
Dim FileList = New DirectoryInfo(SummaryDir).GetFiles(Fin + "*.xls").OrderByDescending(Function(x) x.CreationTime)
For Each f As FileInfo In FileList
lastfile = f.Name
Exit For
Next
Is there a way to avoid the for/next to obtain the last filename?