Is there a way to get a cell to show the current filename?
Printable View
Is there a way to get a cell to show the current filename?
I'm no Excel expert but I was fooling around and came up with this.
=CELL("filename",A1)
(The file has to have been saved)
I was hoping to get just the filename. Not the complete path including the worksheet name.Quote:
Originally posted by MartinLiss
I'm no Excel expert but I was fooling around and came up with this.
=CELL("filename",A1)
(The file has to have been saved)
This is what I came up with so far.Quote:
Originally posted by MartinLiss
I'm no Excel expert but I was fooling around and came up with this.
=CELL("filename",A1)
(The file has to have been saved)
=LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND(".",MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))+3)