Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any formula to insert last document saved date ?
Hi,
We have one shared file,which is updated by every one in the Team, I have to insert a formula in work sheet,it has to updated the Date, when it is modified and saved. is it posible ? Ex : I worked in the work book on 03/24/09 it has to updated the same date. when I open the workbook it has to show the date 03/24/09 (Last saved date). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any formula to insert last document saved date ?
First enter this small UDF:
Function SavedDate() As Date Application.Volatile SavedDate = ActiveWorkbook.BuiltinDocumentProperties.Item(12) End Function Then in a worksheet cell enter: =SavedDate() and format to date -- Gary''s Student - gsnu200840 "DR" wrote: Hi, We have one shared file,which is updated by every one in the Team, I have to insert a formula in work sheet,it has to updated the Date, when it is modified and saved. is it posible ? Ex : I worked in the work book on 03/24/09 it has to updated the same date. when I open the workbook it has to show the date 03/24/09 (Last saved date). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a macro to print the date a document was last saved. | Excel Discussion (Misc queries) | |||
display last date document saved | Excel Worksheet Functions | |||
How do I insert date modified in an Excel document? | Excel Discussion (Misc queries) | |||
How do I insert the date the file was saved in the MS Excel foote. | Excel Discussion (Misc queries) | |||
How to insert date last saved into the sheet (not the footer) | Excel Worksheet Functions |