Modified Date Variable

  • Thread starter Thread starter Joe Blow
  • Start date Start date
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
 
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
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
 
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
 
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!
 
Back
Top