How to show save date

K

Kurt Mayer

Need a function or macro to show the save date of the actual file in any
cell.
How to proceed. How could such a macro be started automatically when the
file is opened.

Thanks, Kurt
 
R

Rowan Drummond

Right click on the Excel Icon just left of the File menu. Select view
code and the paste in the following workbook_open event:

Private Sub Workbook_Open()
Sheets(1).Range("A1").Value = _ 'Change as required
Me.BuiltinDocumentProperties("Last Save Time").Value
End Sub

Hope this helps
Regards
Rowan
 
Top