<div>
Ensure that you escape special characters in your URL using &quot;percent&quot; escape codes.<br />
<br />
<a href="http://www.w3schools.com/tags/ref_urlencode.asp" rel="ugc">http://www.w3schools.com/tags/ref_urlencode.asp</a><br />
<br />
The escape code for an apostrophe is %27<br />
<br />
So if your url was: &nbsp; <a href="http://somewebsite.com/joe's_dessert_recipe.doc" rel="ugc">http://somewebsite.com/joe's_dessert_recipe.doc</a><br />
<br />
Instead put: &nbsp; &nbsp;<a href="http://somewebsite.com/joe%27s_dessert_recipe.doc" rel="ugc">http://somewebsite.com/joe%27s_dessert_recipe.doc</a><br />
<br />
Remember to escape spaces, doublequotes etc. properly. If you do not escape special characters in your URLs properly they are malformed URLs. Word and other web browsers *might* handle it properly, but it is not guaranteed.
</div>


<div>
Thanks Frosty,<br />
<br />
That worked to insert the hyperlink, and it all looks correct, except when I follow the hyperlink, it cannot open the file, and the file path has the %27 instead of the apostrophe. &nbsp;<br />
<br />
I've used the %20 for the spaces, which all works fine, but it doesn't work for the apostrophe.<br />
<br />
Any thoughts?
</div>


<div>
Sorry, I should add that the link to a word doc is being inserted into an email, and it's always worked, except now that someone has a file with an apostrophe in it's name.
</div>


<div>
Hm... maybe Word does not handle the more obscure URL escape codes. Is this Word 2003? Can you post the couple lines of code that you use to generate and insert the hyperlink?
</div>


<div>
It works for the spaces, but not apostrophes. <br />
<br />
Funnily enough, if I hover over the link when it's created, the link looks to be correct, but when I click on it, it shows the %27 where the apostrophe should be, and therefore can't find the file.<br />

<pre><code class="code-1 nolinks" id="code-8169259"><span>Dim strLink As String</span>
<span>Dim currname As String</span>
<span>currname = Replace(thisDoc.FullName, &quot; &quot;, &quot;%20&quot;)</span>
<span>strLink = Replace(currname, &quot;'&quot;, &quot;%27&quot;)</span>
<span></span>
<span>strBody = &quot;&lt;A HREF=&quot; &amp; &quot;file://&quot; &amp; strLink &amp; &quot;&gt;Threats Notification Form&lt;/A&gt;&quot;</span>
</code></pre>
</div>


<div>
Actually if you make the above change, you may be able to *not* do the conversion from apostrophe to %27 and have it work. The missing doublequotes explains why your url was getting truncated at the apostrophe.
</div>


<div>
Thanks - that's perfect. &nbsp;You're right, I don't need to worry about the apostrophe either.
</div>


<div>
<div class="content wysiwyg-content">
I'm using VBA to insert a link to a file that has an apostrophe in it's filename, but when the link is inserted, it doesn't work because it chops the filename off after the apostrophe.<br />
<br />
Any suggestions for how to handle this?<br />
<br />
Thanks.
</div>
</div>


I'm using VBA to insert a link to a file that has an apostrophe in it's filename, but when the link is inserted, it doesn't work because it chops the filename off after the apostrophe.

Any suggestions for how to handle this?

Thanks.

Inserting Hyperlink to a file with an apostrophe in the filename (VBA)

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.