title: How do you open a pdf file with VBA code for a relative file path?
body: <p>I am trying to find the command and correct coding to open a PDF file with a relative file path to the active excel file. The code below works fine as a link directly to the file. However, I just need this code snippet to find the PDF file that is sitting in the same file as the opened excel file and open accordingly.</p>
  
  <pre><code>Sub OpeningPDF()
      'ThisWorkbook.FollowHyperlink "C:\Users\Michael\My Documents\totals\copy.pdf"
  End Sub
  </code></pre>
  
  <p>I tried working with <code>ThisWorkbook.path</code> but nothing I tried with that worked or seemed to be outdate. Any help in this matter would be much appreciated.</p>