Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date file modified
Is there any way (header/footer or in a cell) to display the date the
workbook was modified? I know you can look up the modified date in File/Properties, but don't know how to display that. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date file modified
One way to do this would be to write a Workbook_BeforeSave event macro
that populates a particular cell with the current time and date. That will be a static value that won't change until the next save, and will thereby represent the "last modified" time. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date file modified
'-----------------------------------------------------------------
Function DocProps(prop As String) '----------------------------------------------------------------- Application.Volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentProperties _ (prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function and enter in a cell such as =DocProps ("last author") or =DocProps ("last save time") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Matthew" wrote in message ps.com... Is there any way (header/footer or in a cell) to display the date the workbook was modified? I know you can look up the modified date in File/Properties, but don't know how to display that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time in File Name | Excel Discussion (Misc queries) | |||
Create a copy in the same folder when a file is modified and saved | Excel Discussion (Misc queries) | |||
Can I write an excel formula to display the file save date? | Excel Worksheet Functions | |||
insert the date the file was last modified | Excel Discussion (Misc queries) | |||
How do I add the file last modified date into an Excel header? | Excel Discussion (Misc queries) |