Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"last modified date"
How do I read the system "last modified date" and place it in a document
automatically? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"last modified date"
'----------------------------------------------------------------- Function DocProps(prop As String) '----------------------------------------------------------------- Application.Volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocument*Properties _ (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 (remove nothere from email address if mailing direct) "cnestg8r" wrote in message ... How do I read the system "last modified date" and place it in a document automatically? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
output date modified if data is entered for multiple rows | Excel Discussion (Misc queries) | |||
How do I add the file last modified date into an Excel header? | Excel Discussion (Misc queries) | |||
dynamically enter name of last modified by in spreadsheet on save | Excel Discussion (Misc queries) | |||
How do I enter the date last modified in the footer of an Excel d. | Excel Discussion (Misc queries) | |||
Modified Date | New Users to Excel |