How to show save date

[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

 

[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

 

[Kurt Mayer]

Thanks, Rowan ! It worked fine.
Kurt
---------------------------

 

[Rowan Drummond]

You're welcome.