Thanks for your help all this while. It was very useful all the way.
I am using the following
Set SourceFolder = FSO.GetFolder("C:Path")
For Each FileItem In SourceFolder.Files
'Further operations to be performed bu extracting some data from teh opened files one by one
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I want to modify the above code such that the file is opened based on the last modified date property(I mean the oldest
file to be opened first and sequentially the files are opened with the latest file opened as the last file)
to extract some data from opened files and update another list based on date in ascending order.
Please note that
the date is updated in columns so that i cannot sort by date after the whole list is created. also, the file that i am
updating is a template so I cannot edit it according to my own needs.
Apologize me for such an ambiguous query.
Plese let me know if you do not understand what I exactly mean.