Need to open the last file in my Folder

prasath17 · July 19, 2021, 6:47pm

@Soudios - Below will a array…and your assign statement is string…

please read the below again and add .first at the end…

prasath17:

StrRecentFile and StrOlderFile is String Variables…

StrRecentFile=Directory.GetFiles(ExcelFile1).OrderBydescending(Function(d) New FileInfo(d).LastWriteTime).First

StrOlderFile=Directory.GetFiles(ExcelFile1).OrderBy(Function(d) New FileInfo(d).LastWriteTime).First

Topic		Replies	Views
How do I get the lastest file in the folder Help	15	14679	October 29, 2018
Open only the first file in a series of folders Help	4	1606	May 15, 2019
How to find current directory Help	10	3636	November 19, 2019
Loop files in folder oldest to newest Help activities , question , system	10	1677	January 16, 2021
Get lastest documents in folder in the past hours Help excel , activities , studio	9	1647	February 10, 2019

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

Need to open the last file in my Folder

Related Topics