![]() |
#1
|
|||
|
|||
![]()
Hi all,
![]() I have a hyperlink issue. My Word doc has all these clickable hyperlinks, I am trying to convert the clickable link into a html link Example: Delicious Coffee Converted to <a href="http://www.coffee.com/delicious ">Delicious Coffee </a> Bear Taxonomy <a href =“http://www.bear.com/bearclassification”> Bear Taxonomy </a> etc I only managed to insert the last </a> . The rest I couldn't work out how to do http://windowssecrets.com/forums/sho...RLs-from-links Code:
Sub HyperlinkToParagraph1() Application.ScreenUpdating = False Dim i As Long, Rng As Range With ActiveDocument For i = .Hyperlinks.Count To 1 Step -1 With .Hyperlinks(i) Set Rng = .Range 'Rng.InsertAfter ": " 'Rng.InsertAfter " <a href = " "> Rng.MoveEndUntil cset Rng.Collapse wdCollapseEnd Rng.FormattedText = .Range.FormattedText Rng.Hyperlinks(1).TextToDisplay = .Address Rng.InsertAfter "</a>" .Range.Fields(1).Unlink End With Next End With Application.ScreenUpdating = True End Sub Any help appreciated dan |
#2
|
||||
|
||||
![]()
Try:
Code:
Sub HyperlinkToHRef() Application.ScreenUpdating = False With ActiveDocument While .Hyperlinks.Count > 0 With .Hyperlinks(1) .Range.InsertAfter "<a href=""" & .Address & """>" & .TextToDisplay & "</a>" .Range.Delete End With Wend End With Application.ScreenUpdating = True End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
Paul,
you are a genius!!!!! ![]() Thank you so much - I was having to manually fix these scattered throughout the document. Saved me from this tedious job of finding the hyperlinks then fixing them Much gratitude ![]() dan |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
njcloud | Mail Merge | 23 | 02-04-2020 02:00 PM |
Word 2013's "File > Convert" only partly converts some Hyperlinks | RichardDavey | Word | 0 | 05-27-2015 10:37 AM |
Hyperlinks in PP | ArtemMetr | PowerPoint | 2 | 03-20-2015 01:57 AM |
![]() |
banccard | Word | 1 | 12-22-2011 08:45 PM |
hyperlinks | forrestgump | Word | 0 | 12-30-2010 04:14 AM |