"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION

  • Thread starter Thread starter yossie6
  • Start date Start date
Y

yossie6

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.
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))
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Cell value as filename 1
filename search and extract into a cell 5
Function to put worksheet name in cell returns text, need number 5
Save spreadsheet using cell values as filename 1
A formula to identify tab names in a worksheet 3
Copy worksheets and save files dynamically 3
Need function to insert worksheet name into a cell of that worksheet. 2

Back
Top