Thanks, that did it. It's been a while since I wrote a function and your
help put me right back on track.

Thanks,
Gummby

"Bernie Deitrick" wrote:

You could use a custom function:

Function LSDate()
LSDate = Application.Caller.Parent.Parent. _
BuiltinDocumentProperties("Last Save Time").Value
End Function

Copy the code into a codemodule of your workbook or your personal.xls. Then
it is used like:

=LSDate()

Format the cell for date/time and you're done.

HTH,
Bernie
MS Excel MVP

"Gummby" wrote in message
...
I need to import the Excel file save date into a cell within the file. I
don't need the TODAY() command as that would just show me today's date.
I'm
just trying to automate this field so that I don't have to change it
everytime I make a update to the file.