Save Date

  • Thread starter Thread starter Bas van Heek
  • Start date Start date
B

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
 
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
 
Back
Top