How do I report the filedate in an Excel2000 cell?

[IaSwede]

I want a cell to report the file's creation/last save date, as you can with
&[Date] in the header.
that way it will only update the date when I save the file (before i print
the updated file)

 

[Bob Phillips]

You need a udf

Function DocProps(prop As String)
Aplication.Volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties (prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function


You would use like so

=DOCPROPS("last save time")

--

HTH

RP
(remove nothere from the email address if mailing direct)