Hi,
I have a word document with 14 pages. I want to find all texts starting with “BUC-“ and paste them into a new document. Can any body help me out on this ? By the way I am using MS office word 2007
Hello naflas,
This 2003 Word VBA macro should work in 2007.
'Written: October 24, 2010 'Author: Leith Ross (www.excelforum.com)) Sub FindAndCopy() Dim NewDoc As Document Dim Rng As Range Set NewDoc = Documents.Add Set Rng = ThisDocument.Content With Rng.Find .ClearFormatting .Forward = True .MatchCase = False .MatchAllWordForms = False .MatchFuzzy = False .MatchSoundsLike = False .MatchWildcards = True .Text = "BUC-* " End With Do Rng.Find.Execute If Not Rng.Find.Found Then Exit Do NewDoc.Content.InsertAfter Rng.Text & vbCrLf Rng.Move Loop End Sub
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks