Insert File name in Excel File
 

Hi,

I have insert file name in my execl file by using below formula

=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-
like
(may file name) 571 RU__274880__S.SUHI-47
when i open another file like this file 572 CH__274880__S.SUHI-47 then all file name should be shown same name like 571 RU____ etc.

So, please help

Insert File name in Excel File
 

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

Hi,

Thanks for your support.
It working nicely.

Regards
Shafiq