Troy,

In the cell that you want the filename to appear.

=CELL("filename",A1)

Reference can be any cell in the workbook. It will show the full path
and sheet like.

C:\Documents and Settings\doeJ\My Documents\[Filename.xls]Sheet1


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=506751