View Single Post
 
Old 07-19-2020, 04:15 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Try this
Code:
Sub Hyp2HTML()
  Dim aHL As Hyperlink, sPref As String, aRng As Range
  
  sPref = "<a target='_blank' href='"
  For Each aHL In ActiveDocument.Hyperlinks
    Set aRng = aHL.Range
    aRng.InsertBefore sPref & aHL.Address & "'>"
    aRng.InsertAfter "</a>"
  Next aHL
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote