Hi, I am trying to use the formula below to get the filename of the spreadsheet, it seems to work fine but when you open a second sheet the first sheet will pick up the name of the second.
=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)
These spreadsheets will then be uploaded to another application and having 2 with the same name could cause issues.
Obviously the answer is to only open one at a time, but this is always subject to human error!
Any help would, as always, be appreciated.
Nick