Modified Date Variable

[Joe Blow]

Hello,

I would like to use the modified date variable in a cell. The cell
would display the last modification date to the spreadsheet. Is there
a way to access the properties variable for this purpose?

Thanks,
Joe

 

[Frank Kabel]

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 in a cell
=DOCPROPS("last save time")
(format cell as date)

 

[Joe Blow]

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 in a cell
=DOCPROPS("last save time")
(format cell as date)

Hi Frank,

Thanks, is there a "last mod time"?

Joe

 

[Frank Kabel]

]

Hi Frank,

Thanks, is there a "last mod time"?

Joe

Hi Joe
this is the last time the sheet has been modified AND saved. There's no
such thing build-in like the last time you have entered anything (for
this you'll have to use an event procedure and store it on your own)

Frank

 

[Joe Blow]

]

Hi Frank,

Thanks, is there a "last mod time"?

Joe

Hi Joe
this is the last time the sheet has been modified AND saved. There's no
such thing build-in like the last time you have entered anything (for
this you'll have to use an event procedure and store it on your own)

Frank

Thanks Frank, Appreciate your help. It's working great!