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), "]")
Thanks, Hans. I continue to be amazed at the power of EXCEL. Sometimes I just need a tip from an expert. Thanks again, David Hill in Florida, USA.