Re: Displaying file name in a workbook

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:45BA2396.51434AC5@xxxxxxxxxxxxxxxxxxx
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 Geoff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:6A2CB9FD-B0EB-4FB7-BD2B-6569D0523195@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: calculating a rolling mean
    ... How can I read the last value in that column to another cell? ... >> Earl Kiosterud ... >>> Delboy ... >>> A common mistake that people made when trying to design something ...
    (microsoft.public.excel)
  • Re: Can I add a text stop to a cell?
    ... I struggled for "column border" in my reply and knew it wasn't the ... "Earl Kiosterud" wrote in message ... like a single space character. ... >>> Is there anyway to place a text stop in a cell, ...
    (microsoft.public.excel)
  • Re: Page Numbers in Cells
    ... "Earl Kiosterud" wrote: ... and will calculate and put page numbers in a cell in each page ... > Run this on a copy of the sheet, ...
    (microsoft.public.excel)
  • Re: To share, or to merge, that is the question.
    ... "Earl Kiosterud" wrote: ... can't stuff two users changes into one cell. ... Think through what you want the workbook to look like after two or more users have made ... I tried sharing a workbook, ...
    (microsoft.public.excel.misc)
  • Re: Data Validation list boxes
    ... "Earl Kiosterud" wrote: ... Try that on an errant cell. ... > TITLE is Error Alert ... Look in all three Data Validation tabs. ...
    (microsoft.public.excel.misc)