Groups | Search | Server Info | Login | Register

Macro to expand all hyperlinks in place in a word document (was Re: What's wrong with the Microsoft usenet newsgroups?)

X-Received	by 10.224.42.141 with SMTP id s13mr21996142qae.3.1371993757245; Sun, 23 Jun 2013 06:22:37 -0700 (PDT)
X-Received	by 10.49.13.71 with SMTP id f7mr442965qec.31.1371993757165; Sun, 23 Jun 2013 06:22:37 -0700 (PDT)
Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!j2no154107qak.0!news-out.google.com!fv2ni0qab.0!nntp.google.com!j2no1315180qak.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.sources.d
Date	Sun, 23 Jun 2013 06:22:37 -0700 (PDT)
In-Reply-To	<dd78bcff-1bfa-4f7d-8a10-0b99185a6a46@googlegroups.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=71.123.180.218; posting-account=4DogHwoAAACcnQyUIXIIpmNFupyYV-Fk
NNTP-Posting-Host	71.123.180.218
References	<dd78bcff-1bfa-4f7d-8a10-0b99185a6a46@googlegroups.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<19d5cc30-b086-48a3-bc4e-3a46cddfe832@googlegroups.com> (permalink)
Subject	Macro to expand all hyperlinks in place in a word document (was Re: What's wrong with the Microsoft usenet newsgroups?)
From	sandeep6699@yahoo.com
Injection-Date	Sun, 23 Jun 2013 13:22:37 +0000
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
X-Received-Bytes	2547
Xref	csiph.com comp.sources.d:75

Show key headers only | View raw

On Sunday, June 23, 2013 4:21:31 AM UTC-7, sande...@yahoo.com wrote:
> Hello,
> 
> 
> 
> In the not too recent past, Microsoft Usenet newsgroups like microsoft.public.office.developer.vba and microsoft.public.word.programming used to be very active.  They seem to be comatose now (as are most of the usenet groups).  Any suggestions on what Google groups to use for discussion on VBA macros and things like that?
> 
> 
> 
> SS

It appears that there is life beyond microsoft.public.office.developer.vba and microsoft.public.word.programming.  I had requested help with a macro to expand all hyperlinks in a word document AT THE CORRECT PLACE, but there was no response.  Finally, thanks to the following website, I was able to come up with the macros that I wanted:
http://www.msofficeforums.com/word-vba/11940-word-macro-reformats-embedded-links-doc.html

Sub TagHyperlinks()
Dim HLnk As Hyperlink
For Each HLnk In ActiveDocument.Hyperlinks
  HLnk.Range.InsertAfter " (" & HLnk.Address & ") "
Next
End Sub

Sub TagHyperlinks_selected()
  Dim HLnk As Hyperlink
  With Selection.Find
    For Each HLnk In Selection.Hyperlinks
      HLnk.Range.InsertAfter " (" & HLnk.Address & ") "
    Next
  End With
End Sub

I am a happy person today

SS

Back to comp.sources.d | Previous | Next — Previous in thread | Find similar

Thread

What's wrong with the Microsoft usenet newsgroups? sandeep6699@yahoo.com - 2013-06-23 04:21 -0700
  Macro to expand all hyperlinks in place in a word document (was Re: What's wrong with the Microsoft usenet newsgroups?) sandeep6699@yahoo.com - 2013-06-23 06:22 -0700

csiph-web