![]() |
#2
|
||||
|
||||
![]()
You can't have hyperlinks in a text file, but you can in a Word document. Assuming that you example is a fair representation call the following macro from a loop to open your documents
Code:
Sub AddLinks(oDoc As Document) Dim oPara As Paragraph Dim oRng As Range Dim vPara As Variant Dim strLink As String Dim strDisplay As String Dim lngPara As Long For Each oPara In oDoc.Paragraphs Set oRng = oPara.Range oRng.End = oRng.End - 1 If InStr(1, oRng.Text, "C:\") > 1 Then vPara = Split(oRng.Text, Chr(34)) strDisplay = Trim(vPara(0)) strLink = Trim(Replace(vPara(1), Chr(34), "")) oRng.Text = "" oRng.Hyperlinks.Add Anchor:=oRng, Address:=strLink, TextToDisplay:=strDisplay End If Next oPara lbl_Exit: Set oPara = Nothing Set oRng = Nothing Exit Sub End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
link hyperlink filename |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
bearcublandon | Word VBA | 6 | 01-03-2019 08:17 PM |
![]() |
PABwriter | Word | 4 | 05-27-2016 03:36 PM |
Changing dumb quotes to smart quotes | Reisende | Word | 2 | 05-02-2016 08:56 PM |
![]() |
rideninc | PowerPoint | 1 | 01-28-2014 05:38 AM |
![]() |
Bobosmite | Word | 5 | 04-15-2013 06:40 AM |