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