Can I write an excel formula to display the file save date?
 

In Excel 2003 I often use the following formula to display the name (and
path) of the file:
=CELL("filename",T5)

I have not figured out if there is a way to display other file information
in a cell such as the file save date (& time) or file size.

Is there a way to do this??

Can I write an excel formula to display the file save date?
 

Bob

You can use a UDF to find some properties.

'=DOCPROPS("last author")

'=DOCPROPS("last save time")

'=DOCPROPS("creation date")

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

Don't know the syntax for "file size". Perhaps someone else can jump in with
that.


Gord Dibben MS Excel MVP

On Thu, 26 Jan 2006 10:26:04 -0800, "Bob-123456789"
wrote:

In Excel 2003 I often use the following formula to display the name (and
path) of the file:
=CELL("filename",T5)

I have not figured out if there is a way to display other file information
in a cell such as the file save date (& time) or file size.

Is there a way to do this??