Excel Spreadsheet - Date Modified

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Murp - 27 Jul 2005 05:25 GMT

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.

Signature

Yo Yo Ma.

Reply to this Message

Nikos Yannacopoulos - 27 Jul 2005 08:01 GMT

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

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

Reply to this Message