Hi! I think this should be a fairly easy question: Is there a simple
formula too show the workbook name? I know you can do it in the
header/footer area but i need it to show up in a cell. Any help is
greatly appreciated! Thanks!


--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=479124

enter the following (exactly) into a cell

Code:
--------------------
=CELL("filename")
--------------------


this will give you the entire path, and worksheet.

then use some text functions to trim out the workbook name.


--
i-Zapp
------------------------------------------------------------------------
i-Zapp's Profile: http://www.excelforum.com/member.php...fo&userid=5768
View this thread: http://www.excelforum.com/showthread...hreadid=479124

thank you! Perfect!! :)


--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=479124

I think you'll be better off including a cell reference:

=cell("Filename",a1)

If you don't include that last reference, then this formula will evaluate to the
workbook that was active during the last calculation.

If you open two workbooks and put:
=cell("Filename")
in A1 of a worksheet in each workbook
then use window|arrange|tiled
to see both worksheets,
you'll see the difference.



JENNYC wrote:

thank you! Perfect!! :)

--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=479124

--

Dave Peterson