"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION
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("filenam e"))-SEARCH("[",CELL("filename"))-1))
--
Dave Peterson
|