Report of when Files last updated

S

Swift

Im using Access 2003

I need to create a report to show when some files were last updated.
All the files are *.xls and are in the same folder.

Is there an easy way of doing this?
 
S

storrboy

How do i set the file path?
C:\test\*.xls


Sorry, also look at the Dir() function. It can loop through the files
in a folder then you'd apply the gathered paths to FileDateTime.
 
Top