![]() |
|
|
|
#1
|
|||
|
|||
|
Paul, sorry for late reply. I modified your suggestion to the code below and it worked a treat, many thanks.
Code:
Dim fso As FileSystemObject ' Declare a FileSystemObject.
Dim stream As TextStream ' Declare a TextStream.
Sub Demo()
Dim i As Long, Rng As Range
Dim strMid As String
Set fso = New FileSystemObject ' Create a FileSystemObject.
Set stream = fso.CreateTextFile("C\Test1.txt", True) ' Create a TextStream.
Application.ScreenUpdating = False
With ActiveDocument
For i = .Hyperlinks.Count To 1 Step -1
strMid = Mid(.Hyperlinks(i).Address, 36, 75) '& vbCr
stream.WriteLine (strMid)
Next
End With
' Close the file.
stream.Close
Application.ScreenUpdating = True
End Sub
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Creating a list of Hyperlinks in PPT deck
|
Desiderata | PowerPoint | 5 | 06-16-2016 02:37 AM |
Inserting Only Part of File Name in Word
|
ClaireLivings | Word | 1 | 04-14-2016 08:08 AM |
Multiple part presentation - how to present only a subset of slides + a conclusion ?
|
dchabaut | PowerPoint | 3 | 04-07-2015 10:16 AM |
Copying a part of a docx file as a separate file
|
officeboy09 | Word | 6 | 09-26-2014 05:15 PM |
| Multiple sharepoint list pst file | vik__ | Outlook | 0 | 10-30-2010 02:04 AM |