Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Modified Date
Is there some script that I can use to insert the last modified date of a
workbook into a specific cell?? Dominique |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Modified Date
Hi
you may use the following user defined function: Function DocProps(prop As String) On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentProperties (prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function Now you can use the following formula in one of your cells: =DocProps("Last save time") -- Regards Frank Kabel Frankfurt, Germany Dominique Feteau wrote: Is there some script that I can use to insert the last modified date of a workbook into a specific cell?? Dominique |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Last Date Modified | Excel Worksheet Functions | |||
Modified Date | Excel Discussion (Misc queries) | |||
Date Last Modified | Excel Worksheet Functions | |||
modified date | New Users to Excel | |||
Modified Date | New Users to Excel |