listfilestotable function additional fields (1 Viewer)

matt beamish

Registered User.
Local time
Today, 21:43
Joined
Sep 21, 2000
Messages
208
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

Registered User.
Local time
Today, 16:43
Joined
Jun 8, 2002
Messages
6,195
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.

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

matt beamish

Registered User.
Local time
Today, 21:43
Joined
Sep 21, 2000
Messages
208
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
 

Users who are viewing this thread

Top Bottom