Hello. Here's my dilemma. Hope someone out there can help.

I'm taking data from one program and pasting into Word (with this other
program, there's really no export function, so cutting and pasting is
the only way I can do this). The problem is that when I paste the
information into Word, all of the hyperlinks are "dead" (that is, when
you try to Ctrl+click the link, it does nothing).

Of course, I can manually enter a hard return at the end of the
hyperlink to activate it, but I have a TON of links and don't really
want to spend time doing this. I've tried creating a macro to do this,
and it does everything it should need to do to re-activate the
hyperlink, but it's not.

I'm actually in the VBA window, stepping through the script. I see it
locate the letters "http" and move to the end of the link, then I see
what looks to me like a Return/Enter, but the link never "activates."
Here's the VBA code. Anyone know how I can generate a hard return that
will activate a hyperlink?

Thanks,

Andy

==================

Selection.Find.ClearFormatting
   With Selection.Find
       .Text = "http"
        Selection.EndKey Unit:=wdLine
        Selection.TypeParagraph
       .Replacement.Text = ""
        Selection.TypeParagraph
        .Forward = True
       .Wrap = wdFindContinue
       .Format = False
       .MatchCase = False
       .MatchWholeWord = False
       .MatchWildcards = False
       .MatchSoundsLike = False
       .MatchAllWordForms = False
   End With
   Selection.Find.Execute
End Sub