Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Display Last Saved Date Excel
Hi
I want a cell in the top right corner of my sheet stating the date and time it was last saved as I have a rather unstable network where i work and it crashes. I know this is available in Word and it's a similar kinda thing i'm looking for. Thanks |
#2
|
|||
|
|||
Hi,
I can offer a VBA solution, I don't know Excel worksheet funtion for this purpose. Public Function timestamp(filepathandname) timestamp = FileDateTime(filepathandname) End Function Place this function in a normal module and use it as a UDF. Format the result cell as date/time! Regards, Stefi €˛JonniP€¯ ezt Ć*rta: Hi I want a cell in the top right corner of my sheet stating the date and time it was last saved as I have a rather unstable network where i work and it crashes. I know this is available in Word and it's a similar kinda thing i'm looking for. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
Simple Date Display Question | Excel Discussion (Misc queries) | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
How do I display the last saved date in an EXCEL spreadsheet? | Excel Discussion (Misc queries) | |||
date from query when brought into excel is incorrect | Excel Discussion (Misc queries) |