Modified Date Variable

J

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
 
F

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)
 
J

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)
Click to expand...

Hi Frank,

Thanks, is there a "last mod time"?

Joe
 
F

Frank Kabel

Joe said:
]

Hi Frank,

Thanks, is there a "last mod time"?

Joe
Click to expand...

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
 
J

Joe Blow

Joe said:
]

Hi Frank,

Thanks, is there a "last mod time"?

Joe
Click to expand...

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
Click to expand...

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