Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-12-2017, 11:29 PM
gmayor's Avatar
gmayor gmayor is offline Save highlights within the current selected regions into a fixed document Windows 10 Save highlights within the current selected regions into a fixed document Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The following should work (at least on the PC version of Word), provided the folder you mentioned exists:

Code:
Option Explicit

Sub CopyHighlightsSelectedToOtherDoc()
Dim ThisDoc As Document
Dim ThatDoc As Document
Dim r As Range, orng As Range
Dim fso As Object
    Set fso = CreateObject("Scripting.FileSystemObject")
    Const strDoc As String = "C:\Users\apple\Desktop\container.docx"    'folder must exist
    Set ThisDoc = ActiveDocument
    Set r = Selection.Range
    Set orng = Selection.Range
    If Len(r) > 0 Then
        If fso.FileExists(strDoc) Then
            Set ThatDoc = Documents.Open(strDoc)
        Else
            On Error GoTo err_Handler
            Set ThatDoc = Documents.Add
            ThatDoc.SaveAs2 strDoc
        End If
        With r.Find
            .Highlight = True
            Do While .Execute(Forward:=True) = True And r.InRange(orng)
                ThatDoc.Range.InsertAfter r.Text & vbCrLf
                r.Collapse 0
            Loop
        End With
        ThatDoc.Save
    Else
        MsgBox "Nothing selected"
    End If
lbl_Exit:
    Set r = Nothing
    Set orng = Nothing
    Exit Sub
err_Handler:
    ThatDoc.Close 0
    MsgBox "Target document not available"
    Err.Clear
    GoTo lbl_Exit
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 

Tags
highlighted-text



Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart with Actuals and Goals for Multiple INTL Regions Italiano329 Excel 4 01-22-2016 09:48 AM
Save highlights within the current selected regions into a fixed document VBA to move selected emails or conversation to current year pst folder webharvest Outlook 1 08-15-2015 01:55 AM
Save highlights within the current selected regions into a fixed document Fixed duration, fixed units, fixed work, effort driven. How, why and when use it all Evgeny Project 3 01-03-2013 06:45 AM
Save highlights within the current selected regions into a fixed document How to use fixed duration, fixed work and have resources/units leveled automatically? Joeb Project 3 06-25-2012 04:18 PM
Save Current Slide as Picture excelledsoftware PowerPoint 2 01-18-2012 02:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:54 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