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). |
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). |
All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com