title: Full Hyperlink path in Excel
body: <p>I've got a column in an Excel file, and in it I have only values like 'ReleaseDoc' but they are all hyperlinks to something like this: </p>
  
  <pre><code>\\server1\folder1\subFolderA\subFolderB\SubFolderC\RealseaseDoc.doc
  </code></pre>
  
  <p>Now, what I want to do is to have in another column the path for the file, extracted from the hyperlink, and I've done that with this macro function</p>
  
  <pre><code>Function HLink(rng As Range) As String
  If rng(1).Hyperlinks.Count Then HLink = rng.Hyperlinks(1).Address
  End Function
  </code></pre>
  
  <p>in each cell I call this function with the appropriate cell from where I want to extract the address</p>
  
  <p>The problem is that what I get displayed is something like this:</p>
  
  <pre><code>../../../SubFolderB/SubFolderC/RealeasesDoc.doc
  </code></pre>
  
  <p>I don't see the full path to the docs, can anyone help with this vba function?</p>
  
  <p>PS: I've already searched the posts and found nothing like this</p>
  
  <p>Thank you</p>