Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / January 2005

Tip: Looking for answers? Try searching our database.

Getting rid of hyperlinks

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Oz Springs - 14 Jan 2005 15:20 GMT
I have received a document which is choc-a-block with linked email addresses
which make it hard for me to copy and paste. I don¹t need the links at all.

I have created a macro which goes from one field to the next to remove the
link, and the procedure is semi manual, but I am wondering if there is a
better way of doing this. Is there a way of telling all the links to go away
via a macro?

Thanks for any help

Oz
Jonathan West - 14 Jan 2005 15:27 GMT
>I have received a document which is choc-a-block with linked email
>addresses
[quoted text clipped - 6 lines]
> away
> via a macro?

Hi Oz

Yup, there is.

Sub RemoveHyperlinks()
Dim n as Long
With ActiveDocument.Hyperlinks
 For n = 1 to .Count
   .Item(1).Delete
 Next n
End With
End Sub

This will remove all hyperlinks and leave all other fields intact.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Oz Springs - 14 Jan 2005 15:39 GMT
Thank you very much. A reply in 7 minutes. I didn¹t even have enough time to
return to my laborious semi-manual hyperlink removal.

Kind regards

Oz

On 14/1/05 15:27, in article uVhuF2k#EHA.2876@TK2MSFTNGP12.phx.gbl,

>> I have received a document which is choc-a-block with linked email
>> addresses
[quoted text clipped - 21 lines]
>
> This will remove all hyperlinks and leave all other fields intact.
Jay Freedman - 14 Jan 2005 15:40 GMT
> I have received a document which is choc-a-block with linked email
> addresses which make it hard for me to copy and paste. I don?t need
[quoted text clipped - 8 lines]
>
> Oz

Hi Oz,

If the hyperlinks are the only fields in the document, or if you don't care
about the other fields, you can do it in the GUI with two keystrokes.

   Ctrl+A  -- Select all
   Ctrl+Shift+F9  -- Unlink fields

This converts all fields to plain text of their displayed results.

If there are other fields that need to remain as fields, use this macro to
unlink only the hyperlinks:

Sub UnlinkHyperlinks()
 Dim nHL As Long
 For nHL = 1 To ActiveDocument.Hyperlinks.Count
    ActiveDocument.Hyperlinks(1).Delete
 Next nHL
End Sub

Two notes:
- The .Delete method in VBA does the same as Unlink in the GUI -- it will
leave the display text in place. To remove the entire thing, you need to do
.Hyperlinks(1).Range.Delete.
- As each hyperlink is deleted, the next one becomes .Hyperlinks(1). This
technique is needed because the Hyperlinks collection doesn't work properly
in a For Each loop in which the number of hyperlinks is being changed by
.Delete or .Add.

Signature

Regards,
Jay Freedman
Microsoft Word MVP          FAQ: http://word.mvps.org

Oz Springs - 14 Jan 2005 18:37 GMT
Hi Jay
Thanks for this. I¹ll have to check that I haven¹t replaced Command+Shift+F9
with something else (or if this is a shortcut on a Mac). It will be handy to
know when to convert all fields - instantly.

I¹ll test out the other macro on my document. The one which Jonathan sent me
worked instantly, even quicker than removing one hyperlink with my old
method.

Truly amazed.

Oz

On 14/1/05 15:40, in article OmtoX9k#EHA.1264@TK2MSFTNGP12.phx.gbl, "Jay
Freedman" <jay.freedman@verizon.net> wrote:

>> I have received a document which is choc-a-block with linked email
>> addresses which make it hard for me to copy and paste. I don¹t need
[quoted text clipped - 38 lines]
> in a For Each loop in which the number of hyperlinks is being changed by
> .Delete or .Add.
Jay Freedman - 14 Jan 2005 19:17 GMT
Hi Oz,

Jonathan's macro and mine work the same way. The difference is just in the
way we expressed the names of the hyperlinks in order to delete them.

Signature

Regards,
Jay Freedman
Microsoft Word MVP          FAQ: http://word.mvps.org

> Hi Jay
> Thanks for this. I?ll have to check that I haven?t replaced
[quoted text clipped - 54 lines]
>> work properly in a For Each loop in which the number of hyperlinks
>> is being changed by .Delete or .Add.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.