I would like to create a formula that puts the date the file was last
saved/updated.
Any help is appreciated
Hal
I would like to create a formula that puts the date the file was last
saved/updated.
Any help is appreciated
Hal
You can't do it with a formula, you'd need VBA code like in 'This Workbook'
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Sheet1.Range("A1") = Date
End Sub
Regards,
Alan.
"Hal" <[email protected]> wrote in message
news:[email protected]...
>I would like to create a formula that puts the date the file was last
> saved/updated.
>
> Any help is appreciated
>
> Hal
'-----------------------------------------------------------------
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 such as
=DocProps ("last author")
or
=DocProps ("last save time")
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"Hal" <[email protected]> wrote in message
news:[email protected]...
> I would like to create a formula that puts the date the file was last
> saved/updated.
>
> Any help is appreciated
>
> Hal
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks