Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date last modified macro
Hi guys,
I am wondering if there is a function or maro i can write in excel that can show the date my .xls fle was last modified? So i need it to only change when any cells are changed with in the workbook but if the workbook is opened and just viewed at, the date will not change. I know that information is in the properties of the file but i need it to get that info and put it in a cell. Thanks for the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date last modified macro
In your Microsoft Excel Objects ThisWorkbook, insert this Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Range("A1") = Date 'format your cell to reflect your desired date/time display End Sub Granted this happens only when the wb is saved, if you want it for anytime a cell is changed, you will have to experiment with other built in events. Particularly, you may need to "Dim x as string" to grab the current value on open and have it reuse that value, in the event that, altho the wb is saved, no changes were made. HTH -- AH·C ------------------------------------------------------------------------ AH·C's Profile: http://www.excelforum.com/member.php...o&userid=29108 View this thread: http://www.excelforum.com/showthread...hreadid=488304 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date last modified macro
Hi Leon,
You also have a response to your post in Excel. --- Regards, Norman "Leon" wrote in message oups.com... Hi guys, I am wondering if there is a function or maro i can write in excel that can show the date my .xls fle was last modified? So i need it to only change when any cells are changed with in the workbook but if the workbook is opened and just viewed at, the date will not change. I know that information is in the properties of the file but i need it to get that info and put it in a cell. Thanks for the help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date last modified macro
thanks alot bro ill try it right now
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date last modified macro
Thanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modified Date | Excel Discussion (Misc queries) | |||
Date Last Modified | Excel Worksheet Functions | |||
date that a row is modified | Excel Discussion (Misc queries) | |||
modified date | New Users to Excel | |||
Modified Date | New Users to Excel |