Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Displaying the date a workbook was modified
How doe I insert the date on which the workbook was last saved into a worksheet? -- Bodene ------------------------------------------------------------------------ Bodene's Profile: http://www.excelforum.com/member.php...o&userid=24924 View this thread: http://www.excelforum.com/showthread...hreadid=384824 |
#2
|
|||
|
|||
This code should log the save date and time to cell A1 of the active sheet in the book. Range("A1").ActiveWorkbook.BuiltinDocumentProperti es(12).Value How and where you use the code depends if you need the refreshing of the data to be automatic or manual. HTH Matt "Bodene" wrote: How doe I insert the date on which the workbook was last saved into a worksheet? -- Bodene ------------------------------------------------------------------------ Bodene's Profile: http://www.excelforum.com/member.php...o&userid=24924 View this thread: http://www.excelforum.com/showthread...hreadid=384824 |
#3
|
|||
|
|||
The following should work. In this case it logs the information to cell A1 of
sheet 1 in the active workbook. ActiveWorkbook.Sheets(1).Range("A1") = ActiveWorkbook.BuiltinDocumentProperties(12).Value Note that the document should have been already saved once or an error will arise since the value will be empty. HTH Matt "Bodene" wrote: How doe I insert the date on which the workbook was last saved into a worksheet? -- Bodene ------------------------------------------------------------------------ Bodene's Profile: http://www.excelforum.com/member.php...o&userid=24924 View this thread: http://www.excelforum.com/showthread...hreadid=384824 |
#4
|
|||
|
|||
Thank you for these answers - but what I was looking for was a function similar to one I used to use on Lotus 123 - @info("last-revision-date"). Is there anything similar in Excel? -- Bodene ------------------------------------------------------------------------ Bodene's Profile: http://www.excelforum.com/member.php...o&userid=24924 View this thread: http://www.excelforum.com/showthread...hreadid=384824 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I display the 'Date Modified' in an Excel worksheet header | Excel Discussion (Misc queries) | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
Sheet Modified date in a cell.. ? | Excel Worksheet Functions | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) |