Save Date

[Bas van Heek]

Hi all,

Does anybody know if there is in excel a function or
something else to add the lastest save date to a cell. In
Word you can do this by menu->insert->field... In excel
this option does not exist. Can someone please help me?

Thank you!

By the way, the value does exist. Look in document
properties en the value is there. Now get it to the
worksheet!

Thank you in advance.

Regards,
Bas

 

[GB]

Try

Public Sub test()
MyFileName = ActiveWorkbook.Name
Range("A1") = FileDateTime(MyFileName)
End Sub

This uses VBA - I don't know how to do it with an excel function - other
than writing a custom function that does the same as the above.

Geoff