what's wrong w/ this formula?

i want to import the name of my file into my cell. by looking at help i've been able to do that but dont really undestand the formula properly, which will make it hard to modify.

here's me reverse engineering it. can you please explain why this isn't working, i've getting a #value error.

=MID( CELL("[hello]"), 2, 5)


in the original formula (which works) i used cell("filename") which worked fine. but when im evaluating that formula, rather than it showing up as "Hello.xls" it shows up as "c\doc and set \ excel \ journal \ blah blah blah blah \ ... \. ..... \ etc etc \ Hello.xls" which makes it REALLY hard to decode (esp b/c this path is referred to 3 times in the same code). is there a way to go straight for the name w/o the path?