title: VBA open the folder before
body: <p>I want to open the folder before the current Directory each time. I tried "..\"  but it didn't work, can you help me with that N</p>
  
  <pre><code>ThecurrentDirectory= fso.GetParentFolderName(objFile)
  Set myWorkBook = myxlApplication.Workbooks.Open( ThecurrentDirectory &amp; "\..\CLIENTS.xlsx" )
  </code></pre>