Function lastsaved() As Double
lastsaved = ActiveWorkbook.BuiltinDocumentProperties(12)
End Function

Gives the date/time last saved

For the properites of closed files, see:

http://www.cpearson.com/excel/docprop.htm
Document Properties Of Closed Files DSO Version 2.0
--
Gary's Student


"HROBERTSON" wrote:

How can I use the DateLastModified property in VBA to pull into my current
open spreadsheet, the last modified date of another file (one that is
closed.) I want, if possible, to add it to a cell.

As always, your help is greatly appreciated.

Thank You!