Need a complicated formula to display part of current workbook name in a cell

Hi all.

I want to insert the name of the current workbook into a cell in my workbook. I got this formula from the Microsoft website, which gives the name of the workbook including the full path:

=CELL("filename")

Then I got this, which takes me a step closer, and gives me just the name of the workbook, including the extension:

=((MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)))

but what I really need is the name of the current workbook, minus the ".xls" extension from the right-hand side, but also minus 25 characters from the left-hand side. Is this possible? I'm guessing I would have to use the LEN function somewhere (twice) in combination with LEFT and RIGHT, but I can't work it out.

So would it be possible for me combine all of that into the existing formula? Or would that be stretching it? Maybe I could use a couple of hidden cells, and do it three steps at a time?

Never mind, I found the solution online (to refer to the current cell with each "filename"). Thanks!

Ah ok, I see what you did there. It does work, but I have a problem. If I open another workbook in the same instance of Excel, it changes the filename to that of the other workbook, and therefore the contents of the cell. Is there a way I can make the cell formula only reference the current workbook?

It's ok, it's working fine for me now, so I don't dare change it! But thanks anyway

Of course I do! It's just that I don't dare change something if it's already working, because in my experience it inevitably breaks, and I forget how I had it when it worked! If I can have a fully working version of the project that I can put in a completely separate folder, THEN I can tinker with it!

Tell you what, for now I'll compromise and make a copy of the formula, and then I can try it later. At the moment I'm trying to get some critical processes working properly, and I need to get that done first!