Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
how can i insert into a cell the last update of the document that I can see
in the statistic or MSDOS in the General Tap. Regards, Ramiro |
#2
![]() |
|||
|
|||
![]()
Hi
use the following UDF: 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 for example in a cell (to get the last modification date) =DOCPROPS("last save time") (format cell as date) -- Regards Frank Kabel Frankfurt, Germany "Ramiro Cubillan" schrieb im Newsbeitrag ... how can i insert into a cell the last update of the document that I can see in the statistic or MSDOS in the General Tap. Regards, Ramiro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell update??? | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Timestamp cell to left after update | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
parse cell and insert rows? | Excel Worksheet Functions |