Forum Discussion
Solved
EXCEL
Is there an EXCEL function that returns the current (open) filename? Is there an EXCEL function that returns the current (open) worksheet name?
Perhaps
=TEXTBEFORE(TEXTAFTER(CELL("filename", A1), "["), "]")
and
=TEXTAFTER(CELL("filename", A1), "]")
You may use =CELL("filename") and parse returned text. If only you are not on Excel for Web.
Lot of samples how to use, google for them.