Cell value as filename

[chas975]

I am trying to find a way to make a "cell value" read the "filename" automatically. Similar to how you autoformat a footer to read the filename. Can anyone offer any advice?

[papou]

Hello
Formula in A1 :
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,SUM(FIND({"[";"]"},CELL("filename",A1))*{-1;1})-1)
nb: workbook must be saved

HTH
Cordially
Pascal

"chas975" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> I am trying to find a way to make a "cell value" read the "filename"
> automatically. Similar to how you autoformat a footer to read the
> filename. Can anyone offer any advice?
>
>
> --
> chas975
> ------------------------------------------------------------------------
> chas975's Profile:
> http://www.excelforum.com/member.php...o&userid=34530
> View this thread: http://www.excelforum.com/showthread...hreadid=542929
>