|
Posted to microsoft.public.excel.misc
|
|
|
show last date saved in excel
Thank you this worked.
"Gord Dibben" wrote:
First off.........save a backup of your workbook.
Then use this User Defined Function
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
'=DOCPROPS("last author")
'or
'=DOCPROPS("last save time")
'or
'DOCPROPS("creation date")
If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".
http://www.mvps.org/dmcritchie/excel/getstarted.htm
In the meantime..........
To create a General Module, hit ALT + F11 to open the Visual Basic Editor.
Hit CRTL + R to open Project Explorer.
Find your workbook/project and select it.
Right-click and InsertModule. Paste the above code in there. Save the
workbook and hit ALT + Q to return to Excel window.
Enter the formula as shown above.
Gord Dibben Excel MVP
On Mon, 28 Aug 2006 15:28:02 -0700, k2224z
wrote:
how do I show the last date that the file was saved in a cell in the file
Gord Dibben MS Excel MVP
|