Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-31-2019, 06:11 AM
coolio2341 coolio2341 is offline Find several words in document, copy paragraph and create new document Windows 7 64bit Find several words in document, copy paragraph and create new document Office 2013
Novice
Find several words in document, copy paragraph and create new document
 
Join Date: Jan 2019
Posts: 4
coolio2341 is on a distinguished road
Default

Thank you thank you Greg Maxey!







Quote:
Originally Posted by gmaxey View Post
Code:
Sub ScratchMacro()
 'A basic Word macro coded by Greg Maxey, http://gregmaxey.com/word_tips.html, 01/31/2019
Dim oRng As Range
Dim arrFind() As String
Dim lngIndex As Long
Dim strContent
Dim oThisDoc As Document
Dim oDoc As Document
  
  Set oThisDoc = ActiveDocument
  arrFind = Split("1945,1946,1947", ",")
  For lngIndex = 0 To UBound(arrFind)
    oThisDoc.Activate
    strContent = vbNullString
    Set oRng = ActiveDocument.Range
    With oRng.Find
      .ClearFormatting
      .Text = arrFind(lngIndex)
      .Forward = True
      .Wrap = wdFindStop
      .Format = False
      .MatchCase = False
      .MatchWholeWord = False
      .MatchWildcards = False
      .MatchSoundsLike = False
      .MatchAllWordForms = False
      Do While .Execute
        strContent = strContent & oRng.Paragraphs(1).Range.Text & vbCr
      Loop
      If strContent <> vbNullString Then
        Set oDoc = Documents.Add(, , wdNewBlankDocument)
        oDoc.Range.Text = strContent
      End If
    End With
  Next lngIndex
lbl_Exit:
  Exit Sub
End Sub
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find several words in document, copy paragraph and create new document Find and highlight multiple words in MS Word document AtaLoss Word VBA 37 09-22-2021 12:04 PM
Find several words in document, copy paragraph and create new document Macro to search for a particular word, copy the entire paragraph to a new document Productivity Word VBA 2 10-25-2019 06:40 AM
Copy text to new document based on paragraph numbering mike.mm Word VBA 7 11-22-2016 06:14 AM
Find several words in document, copy paragraph and create new document How to select and copy to clipboard an entire document except for a paragraph and keep formatting TD_123 Word VBA 7 06-16-2015 03:30 PM
Find and highlight multiple words in a document flatop Word VBA 3 04-16-2014 10:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:53 PM.


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