![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
|
||||
|
||||
|
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 |
| 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 |
VBA to move selected emails or conversation to current year pst folder
|
webharvest | Outlook | 1 | 08-15-2015 01:55 AM |
Fixed duration, fixed units, fixed work, effort driven. How, why and when use it all
|
Evgeny | Project | 3 | 01-03-2013 06:45 AM |
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 |