Report of when Files last updated

[Guest]

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?

 

[storrboy]

Look at the FileDateTime(pathname) function?

 

[Guest]

Look at the FileDateTime(pathname) function?

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

 

[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.