date last saved
 

Dear all,

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

Many thanks

Kevin

date last saved
 

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

date last saved
 

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


.

date last saved
 

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


.