Dear all,

What is the Excel command to display the date the file was
last saved?

Many thanks

Kevin

Hi Kevin

ActiveCell.Value = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")

Here is a example for printing
http://www.rondebruin.nl/print.htm#Saved

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kevin Smith" wrote in message ...
Dear all,

What is the Excel command to display the date the file was
last saved?

Many thanks

Kevin

Thanks for this. I was after an Excel command rather that
VBA script.

Thanks

Kevin

-----Original Message-----
Hi Kevin

ActiveCell.Value =
ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")

Here is a example for printing
http://www.rondebruin.nl/print.htm#Saved

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kevin Smith" wrote in
message ...
Dear all,

What is the Excel command to display the date the file
was
last saved?

Many thanks

Kevin


.

I was after an Excel command
Don't exist

Bob have posted this function
You can use it in a worksheet cell then

use the following UDF (only on workbook level):

Function DocProps(prop As String)
application.volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function

and enter in a cell
=DOCPROPS("last save time")
(format cell as date)

for more about UDFs see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kevin Smith" wrote in message ...
Thanks for this. I was after an Excel command rather that
VBA script.

Thanks

Kevin

-----Original Message-----
Hi Kevin

ActiveCell.Value =
ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")

Here is a example for printing
http://www.rondebruin.nl/print.htm#Saved

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kevin Smith" wrote in
message ...
Dear all,

What is the Excel command to display the date the file
was
last saved?

Many thanks

Kevin


.