EXCEL

[WittyGuy55]

Is there an EXCEL function that returns the current (open) filename?

Is there an EXCEL function that returns the current (open) worksheet name?

[#2 · Accepted solution]

@WittyGuy55 

Perhaps

=TEXTBEFORE(TEXTAFTER(CELL("filename", A1), "["), "]")

and

=TEXTAFTER(CELL("filename", A1), "]")

[#3]

@WittyGuy55 

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.

[#4]

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.