Hi,

Am Mon, 8 Oct 2012 04:46:24 +0000 schrieb sk.shafiqul:

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-24)

it is working nicely. But when i opening multiple file at a time, then
all file name are showing same name-

you have to refer to your workbook. Try:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2