Insert filepath as hyperlink Excel VBA
<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>