Is there any way that the filename of a workbook can be displayed in a cell.

A bit like the "TODAY" function displays the current date, is there a
function to display the current file name of the workbook

See he http://support.microsoft.com/kb/323225

Dave
--
Brevity is the soul of wit.


"Premier Geoff" wrote:

Is there any way that the filename of a workbook can be displayed in a cell.

A bit like the "TODAY" function displays the current date, is there a
function to display the current file name of the workbook

Geoff,

=CELL("filename")
--
Earl Kiosterud
www.smokeylake.com

-----------------------------------------------------------------------
"Premier Geoff" <Premier wrote in message
...
Is there any way that the filename of a workbook can be displayed in a
cell.

A bit like the "TODAY" function displays the current date, is there a
function to display the current file name of the workbook

That was the Mac version; http://support.microsoft.com/kb/214084/EN-US/ is
for Windows.
--
David Biddulph

"Dave F" wrote in message
...
See he http://support.microsoft.com/kb/323225
"Premier Geoff" wrote:

Is there any way that the filename of a workbook can be displayed in a
cell.

A bit like the "TODAY" function displays the current date, is there a
function to display the current file name of the workbook

I think:

=cell("filename",a1)
will be better.

If a range reference isn't included, then the formula will evaluate to whatever
workbook is active at the time of the last calculation.

Earl Kiosterud wrote:

Geoff,

=CELL("filename")
--
Earl Kiosterud
www.smokeylake.com

-----------------------------------------------------------------------
"Premier Geoff" <Premier wrote in message
...
Is there any way that the filename of a workbook can be displayed in a
cell.

A bit like the "TODAY" function displays the current date, is there a
function to display the current file name of the workbook



--

Dave Peterson

Dave,

Thanks. That one's not in the help for the CELL() function, so I think this
is officially another Excel gotcha!
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dave Peterson" wrote in message
...
I think:

=cell("filename",a1)
will be better.

If a range reference isn't included, then the formula will evaluate to
whatever
workbook is active at the time of the last calculation.

Earl Kiosterud wrote:

Geoff,

=CELL("filename")
--
Earl Kiosterud
www.smokeylake.com

-----------------------------------------------------------------------
"Premier Geoff" <Premier wrote in
message
...
Is there any way that the filename of a workbook can be displayed in a
cell.

A bit like the "TODAY" function displays the current date, is there a
function to display the current file name of the workbook



--

Dave Peterson