Hello,
I realise that this is by no means a current thread but having just tried it out I thought I should feed back my findings:
If you have two worksheets open that both use any of these formulas the first one opened will display correctly until the second one is opened, whereupon it will display the filename of the second file. Pressing F9 to recalculate will result in both worksheets displaying the filename of the currently active sheet.
The formula is great, but is there anyway around the above little problem?
Kind regards
Benjamin
Quote:
Originally Posted by Steve
Thanks, Ron, it worked! I also found that this works as well (removes last 4
digits by changing -1 to -5, but I like your solution better:
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-5)
"Ron Coderre" wrote:
Maybe something like this?:
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,
SEARCH(".xl?]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Steve" wrote:
I know that I can enter a cell file name with the following typed into the
cell:
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)
But, can I do this without showing the file extension (.xls)?
|