How to get filename and last modified and write to excel


#1

Hi All,

I want to get the filename for each file (using for each row) and then write the filename and last modified time to excel


I want to collect the xxx.mdb name file and modified time and write to excel.
How to do this because im not have an idea how to get the modified date (still learning)

Thanks

Regards

Delf


#2

use directory.getfiles() this will create an array that contains all files from the specified folder.
use a for each on the array you just created, then IO.File.GetLastWriteTime(fileName).ToString will get you the date you want.


#3

Hi @Tiberiu_Niculescu,

PFA.

Thanks
GirishGetFileNameandLastModifiedIntoExcel.xaml (14.1 KB)


#4

Hi @Girish

Works like a charm… thank you very much

Regards

Delf