Insert file name in cells
I need to insert the file name in a cell of the work page (with a funtion)
and be able to change automatically if & when the file name id edited. I Use this on a cover page . |
Insert file name in cells
Deare De Silva,
Try the following array formula (Ctrl+Shift+Enter) =MID(CELL("filename"),MATCH("[",MID(CELL("filename"),ROW(1:150),1),0)+1,MATCH(". ",MID(CELL("filename"),ROW(1:150),1),0)-MATCH("[",MID(CELL("filename"),ROW(1:150),1),0)-1) WHen you change the filename, i guess you would have to vlose and reopen the file. Regards, Ashish Mathur "Mohan De Silva" wrote: I need to insert the file name in a cell of the work page (with a funtion) and be able to change automatically if & when the file name id edited. I Use this on a cover page . |
Insert file name in cells
Hello Ashish,
Tried entering the formula, but give result #VALUE!. What do you mean by (Ctrl+Shift+Enter) is this to be done in the cell before entering the formula ?? Thanks & appreciate assistance Mohan De Silva "Ashish Mathur" wrote: Deare De Silva, Try the following array formula (Ctrl+Shift+Enter) =MID(CELL("filename"),MATCH("[",MID(CELL("filename"),ROW(1:150),1),0)+1,MATCH(". ",MID(CELL("filename"),ROW(1:150),1),0)-MATCH("[",MID(CELL("filename"),ROW(1:150),1),0)-1) WHen you change the filename, i guess you would have to vlose and reopen the file. Regards, Ashish Mathur "Mohan De Silva" wrote: I need to insert the file name in a cell of the work page (with a funtion) and be able to change automatically if & when the file name id edited. I Use this on a cover page . |
Insert file name in cells
Check out this web page of John McGimpsey on the subject:
http://www.mcgimpsey.com/excel/formu..._function.html -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Mohan De Silva" wrote in message ... Hello Ashish, Tried entering the formula, but give result #VALUE!. What do you mean by (Ctrl+Shift+Enter) is this to be done in the cell before entering the formula ?? Thanks & appreciate assistance Mohan De Silva "Ashish Mathur" wrote: Deare De Silva, Try the following array formula (Ctrl+Shift+Enter) =MID(CELL("filename"),MATCH("[",MID(CELL("filename"),ROW(1:150),1),0)+1,MATC H(".",MID(CELL("filename"),ROW(1:150),1),0)-MATCH("[",MID(CELL("filename"),R OW(1:150),1),0)-1) WHen you change the filename, i guess you would have to vlose and reopen the file. Regards, Ashish Mathur "Mohan De Silva" wrote: I need to insert the file name in a cell of the work page (with a funtion) and be able to change automatically if & when the file name id edited. I Use this on a cover page . |
Insert file name in cells
=CELL("filename",A1)
File must be saved before it will work...... Vaya con Dios, Chuck, CABGx3 "Mohan De Silva" wrote in message ... I need to insert the file name in a cell of the work page (with a funtion) and be able to change automatically if & when the file name id edited. I Use this on a cover page . |
Insert file name in cells
Mohan
Check out Bob Phillips' site for this. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben Excel MVP On Thu, 22 Dec 2005 15:52:02 -0800, "Mohan De Silva" wrote: I need to insert the file name in a cell of the work page (with a funtion) and be able to change automatically if & when the file name id edited. I Use this on a cover page . |
All times are GMT +1. The time now is 09:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com