listfilestotable function additional fields

[matt beamish]

Would someone be able to show me how to add the file last modified date to the fields picked up by the function "listfilestotable"

the function is here
http:////allenbrowne.com/ser-59alt.html


I want to build my list of files on a shared data area and then sort using last modified date.

Thanks very much

Matt

 

[ghudson]

Check out how I do it when you open the fScanDirSelectFileFromTable form in my Browse [Find a directory or file] sample. The result are in the tFiles table in my sample.

ModifiedDate = FileDateTime("X:\YourFile.txt")

 

[matt beamish]

thanks for the reply. I had a go at shoe-horning your modified date into the function, but my vba is too novice to get any success, and I end up breaking what was working previously! I can see where code needs changing to suit my options, but adding in variables and getting the syntax right is beyond me at the moment...
thanks anyway

Matt