Formula to open current folder one level up

schielrn

Well-known Member

Joined

Apr 4, 2007

Messages

6,941

• Jul 29, 2008

• #11

Actually I haven't tested this fully, but it may work:

=MID(CELL("filename"),1,FIND("[",CELL("filename"))-1)&".."

If you use that I believe it shows up as the incorrect path visually, but I believe it will point to one level up.

 

Upvote 0

schielrn

Well-known Member

Joined

Apr 4, 2007

Messages

6,941

• Jul 29, 2008

• #12

After testing it I couldn't get it to work exactly, so I am back to square one, without being able to use it in a formula.

 

Upvote 0

Jonmo1

MrExcel MVP

Joined

Oct 12, 2006

Messages

44,061

• Jul 29, 2008

• #13

Me too, I got it to work in VBA, say if that formula is in A1, this will open a file 1 folder up..

Workbooks.Open Range("A1").Value & "\test.xls"

That works...

 

Upvote 0

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,264

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Jul 29, 2008

• #14

You can use the .. in the Workbooks.Open:

Code:

workbooks.Open "..\Book1.xls"

opens Book1 from the parent directory of the current directory.

 

Upvote 0

Jonmo1

MrExcel MVP

Joined

Oct 12, 2006

Messages

44,061

• Jul 29, 2008

• #15

I knew that, I was just doing that to verify the formula pointed to the correct folder even though it displays the wrong one...

 

Upvote 0

Richard Schollar

MrExcel MVP

Joined

Apr 19, 2005

Messages

23,707

• Jul 29, 2008

• #16

jonmo1 said:

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

Click to expand...

Hey that's useful! Thanks, Jonmo!

 

Upvote 0

Jonmo1

MrExcel MVP

Joined

Oct 12, 2006

Messages

44,061

• Jul 29, 2008

• #17

Hey that's useful! Thanks, Jonmo!

Click to expand...

Always glad to know I found something cool...
But give credit where it's due, I only found that as a follow up on Rorya's first post..

 

Upvote 0