Excel Formula for File Name but Do Not Change if Workbook Not Active

[OilEconomist]

Thanks in advance for any suggestions for which feedback will be given.

Is there a formula that you can put into a cell that will get the name of that file and not necessarily the active file? When I switch files, the cell changes to the active file even though the active file is a different file.

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH(".",CELL("filename"))-1-SEARCH("[",CELL("filename")))

 

[bobsan42]

Use a cell reference in the file as optional function argument:

CELL("filename",$A$1)

 

[OilEconomist]

bobsan42 thanks so much as that worked perfectly

Can $A$1 be any cell? What if it has a value in it.

 

[bobsan42]

You can use any cell regardless of its contents.