title: opening excel file in the same directory
body: <p>I am trying to open a new workbook which is there in the same directory as my current workbook. I saw this command to open it, but it is showing me an error. The error says that it cannot find the file in another directory.</p>
  
  <pre><code>Workbooks.Open (ThisWorkbook.Path &amp; "\source.xlsx")
  </code></pre>
  
  <p>The above command does not open the file source.xlsx and in the error, it is trying to look in the folder c:\user\username\AppData ....</p>