there are more side effects like when there are few files open that
have the same form the name of the closed file transfered to the
remain one.
i used this formula
(MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH(".",CELL("filename"))-SEARCH("[",CELL("filename"))-1))

Use
=cell("Filename",a1)

Without the range reference, excel will use the whatever worksheet/workbook that
is active to evaluate that function.

You can really use any cell you want. I usually use the address of the cell
that holds the formula.

yossie6 wrote:
>
> there are more side effects like when there are few files open that
> have the same form the name of the closed file transfered to the
> remain one.
> i used this formula
> (MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH(".",CELL("filename"))-SEARCH("[",CELL("filename"))-1))

--

Dave Peterson