Formula to open current folder one level up

[ttratl]

Hi Everyone,

I have this formula that opens the current folder where my file is stored:

=HYPERLINK(MID(CELL("filename"),1,FIND("[",CELL("filename"))-1),"Open Current Folder")

This works fine. I'd like it to open the folder one level up from the current folder, but I really don't understand formulas well enough to know if this is even possible.

Any ideas?

Thanks

 

[RoryA]

Try this:

=HYPERLINK(MID(CELL("filename"),1,FIND("[",CELL("filename"))-1)&"..","Open Current Folder")

HTH

 

[Jonmo1]

That's really cool rorya.

I thought it was going to involve a complex find/substitute/len to get the 2nd to last "/" and such...

 

[RoryA]

So did I, then I had a DOS flashback!

 

[Jonmo1]

Hmm, You're formula got me thinking Rorya....

now you're gonna have a laugh at this...

Try this..

=HYPERLINK(".","Hello") = Current folder
=HYPERLINK("..","Hello") = One folder up

 

[ttratl]

Rorya,

Perfect! Thanks very much!

 

[Jonmo1]

=HYPERLINK("..\..","Hello") = Two folders up
=HYPERLINK("..\..\..","Hello") = Three Folders up

you can just go on and on....Sweet..

 

[RoryA]

How did I not see that?? Nice one.

 

[Jonmo1]

I wonder if there's any way to use that method to return the TEXT string of that path so you could use it in a formula ? That sure would be easier than the find/substitute/len method on the nth "\"

 

[schielrn]

I wonder if there's any way to use that method to return the TEXT string of that path so you could use it in a formula ? That sure would be easier than the find/substitute/len method on the nth "\"

Nevermind, what I thought had wasn't actually the directory I was looking at.

Sorry.