Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
Thanks for your support. It working nicely. Regards Shafiq |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to insert row in a linked file through main file. | Excel Programming | |||
how to insert row in a linked file through main file. | Excel Programming | |||
Insert an excel file into the current open excel file | Excel Discussion (Misc queries) | |||
problem with insert Excel file in another Excel file | New Users to Excel | |||
Macro to insert values from a file and save another sheet as a .txt file | Excel Programming |