title: Relative instead of Absolute paths in Excel VBA
body: <p>I have written an Excel VBA macro which imports data from a HTML file (stored locally) before performing calculations on the data.</p>
  
  <p>At the moment the HTML file is referred to with an absolute path:</p>
  
  <pre><code>Workbooks.Open FileName:="C:\Documents and Settings\Senior Caterer\My Documents\Endurance Calculation\TRICATEndurance Summary.html"
  </code></pre>
  
  <p>However I want to use a relative path to refer to it as opposed to absolute (this is because I want to distribute the spreadsheet to colleagues who might not use the same folder structure).  As the html file and the excel spreadsheet sit in the same folder I would not have thought this would be difficult, however I am just completely unable to do it.  I have searched on the web and the suggested solutions have all appeared very complicated.</p>
  
  <p>I am using Excel 2000 and 2002 at work, but as I plan to distribute it I would want it to work with as many versions of Excel as possible.</p>
  
  <p>Any suggestions gratefully received.</p>