Excel Spreadsheet - Date Modified

[Guest]

Is it possible to retrieve the date an excel spreadsheet was modified outside
of Access using code? I want to use it for comparison in a function.

 

[Nikos Yannacopoulos]

Murp,

Try this:

Dim fldr, fl
Dim extfile As String
Dim lstmodif As Date

extfile = "SomePathAndFileName.xls"
Set fldr = CreateObject("Scripting.FileSystemObject")
Set fl = fldr.getfile(extfile)
lstmodif = fl.DateLastModified
Set fl = Nothing
Set fldr = Nothing

HTH,
Nikos