Excel Spreadsheet - Date Modified

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top