title: Insert filepath as hyperlink Excel VBA
body: <p>I have a VBA set of code that generates an email and automatically sends it.</p>
  
  <p>One of the things that I cannot get to work properly is putting a hyperlink to a specified folder location within the email.</p>
  
  <pre><code>Dim fpath As String
  
  fpath = Worksheets("MS_JRNL_OPEN_TU_FR-4333635").Range("AD5").Value
  
  "file://" &amp; fpath &amp; _
  </code></pre>
  
  <p>Essentially the user has to input a folder location when running the Macro which is in Cell AD5, but I want this is appear as the full folder location as a hyperlink once the email is generated.</p>
  
  <p>Any help would be greatly appreciated</p>