Up One Level ?

  • Thread starter Thread starter Phil vK
  • Start date Start date
P

Phil vK

In Excel 2010 beat, is there a "Up One Level" arrow when one is saving a
file? Without it I have to go thru the entire folder tree to get to the
location where I want to save a file. Maddening.
 
See if this helps

Sub GetParentPath()
mydir = ActiveWorkbook.Path
MsgBox mydir
MsgBox Left(mydir, InStrRev(mydir, "\"))

'ChDir ActiveWorkbook.Path
'ChDir ".."
End Sub
 
Back
Top