Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-15-2017, 07:51 PM
saltire1963 saltire1963 is offline Windows 10 Office 2016
Novice
List part of multiple hyperlinks in .txt file
 
Join Date: Aug 2017
Posts: 2
saltire1963 is on a distinguished road
Default

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
List part of multiple hyperlinks in .txt file Creating a list of Hyperlinks in PPT deck Desiderata PowerPoint 5 06-16-2016 02:37 AM
List part of multiple hyperlinks in .txt file Inserting Only Part of File Name in Word ClaireLivings Word 1 04-14-2016 08:08 AM
List part of multiple hyperlinks in .txt file Multiple part presentation - how to present only a subset of slides + a conclusion ? dchabaut PowerPoint 3 04-07-2015 10:16 AM
List part of multiple hyperlinks in .txt file 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft