software

In Excel 2003 I often use the following formula to display the name (and
path) of the file:
=CELL(quot;filenamequot;,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 (amp; time) or file size.

Is there a way to do this??

Bob

You can use a UDF to find some properties.

'=DOCPROPS(quot;last authorquot;)

'=DOCPROPS(quot;last save timequot;)

'=DOCPROPS(quot;creation datequot;)

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 quot;file sizequot;. Perhaps someone else can jump in with
that.Gord Dibben MS Excel MVP

On Thu, 26 Jan 2006 10:26:04 -0800, quot;Bob-123456789quot;
gt; wrote:

gt;In Excel 2003 I often use the following formula to display the name (and
gt;path) of the file:
gt;=CELL(quot;filenamequot;,T5)
gt;
gt;I have not figured out if there is a way to display other file information
gt;in a cell such as the file save date (amp; time) or file size.
gt;
gt;Is there a way to do this??