There may be times when you need to insert the name of the current workbook or worksheet in to a cell.
=CELL("filename")
The problem with this is that it gives the complete path including drive letter and folders.
Pick the Excel Path.
=MID(CELL("filename"),1,FIND("[",CELL("filename"))-1)
Pick the Workbook name.
=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)
Pick the Worksheet name.
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
