How do I display the last saved date in an EXCEL spreadsheet?
 

--
Andrea

Where in the sheet?

In a cell.........

Copy/paste this Function to a module in your workbook.

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

Usage in a cell is: =DOCPROPS("last save time")

Format the cell as Date.

You can also use "last author" or "creation date"

If not familiar with macros and VBA, visit David McRitchie's website 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 your workbook.


Gord Dibben Excel MVP



On Thu, 10 Mar 2005 08:33:04 -0800, Andrea
wrote: