You must save the file at least once before these formulas will work.

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-5)

returns name -without extension "Filename"

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

returns name with extension "Filename.xls"


"Troy" wrote:

But what if I want only the file anme to show and not the entire path? Also,
what exactly goes in the cell? I am looking at your post and not sure how to
insert the information.

"SteveG" wrote:


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