troubleshooting Question

Word macro changing style format?

Avatar of lherrou
lherrouFlag for Wallis and Futuna asked on
VB ScriptMicrosoft OfficeMicrosoft Word
11 Comments1 Solution112 ViewsLast Modified:
I am using some Microsoft VB code for a macro to convert text links in a Merge-created 200-page document to clickable hyperlinks. The problem I have is that when the macro runs, it also changes some other styles. Is there an easy way to modify the Range to include only hyperlinks?

Sub ConvertURLTextsToHyperlinksInDoc()
  Dim objDoc As Document
  Set objDoc = ActiveDocument
  Word.Options.AutoFormatReplaceHyperlinks = True
End Sub
Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros