title: Open folder using variable Path
body: <p>I am trying to open the folder where the macro workbook is located.</p>
  <p>In this example, it is in folder &quot;H:\Projects\IWA_Populate&quot;. However, the workbook could be in any folder location.</p>
  <p>If I specify a static path as below it opens to the target folder IWA_Populate:</p>
  <pre><code>Shell &quot;explorer.exe H:\Projects\IWA_Populate&quot;, vbNormalFocus
  </code></pre>
  <p>However if I replace the path with a variable as such below it only opens My Documents folder.</p>
  <pre><code>Shell &quot;explorer.exe file_path&quot;, vbNormalFocus
  </code></pre>
  <p>Here is my code to get file_path initialized:</p>
  <pre><code>Public file_path As String
  Public xl As Excel.Application
  Set xl = Application: xl.DisplayAlerts = False
  ActiveWorkbook.Save
  file_path = xl.ActiveWorkbook.Path
  'Shell &quot;explorer.exe H:\Projects\IWA_Populate&quot;, vbNormalFocus
  Shell &quot;explorer.exe file_path&quot;, vbNormalFocus
  MsgBox file_path
  </code></pre>
  <p>The Message box is to test that <code>file_path</code> is set to the correct full path.</p>