Home |
Search |
Today's Posts |
#1
|
|||
|
|||
DateLastModified
Hi! I´m making a macro on Excel 2003 and i have to find how to show the date
of the last modified in a workbook. Someone can help me? |
#2
|
|||
|
|||
Hi
ActiveWorkbook.BuiltinDocumentProperties("Last Save Time").Value -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "nina" wrote in message ... Hi! I´m making a macro on Excel 2003 and i have to find how to show the date of the last modified in a workbook. Someone can help me? |
#3
|
|||
|
|||
Using VBA
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 =DOCPROPS("last save time") (format cell as date) This is a custom UDF, so you need to place the code in a normal code module. -- HTH RP (remove nothere from the email address if mailing direct) "nina" wrote in message ... Hi! I´m making a macro on Excel 2003 and i have to find how to show the date of the last modified in a workbook. Someone can help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|