MSAccess VBA Find Text in Word Document Select All Text After Find

Question

I want MS Access to search for text in a Word document and then, when it has found the text, select all of the text following the find to be analysed further within Access. I have the code working which finds the text using Range.Find, however, how can I then identify where to start my selection from so that I can grab the remaining text for analysis?

Please show us your code - otherwise it is hard to help you. — Ike
– Ike, Commented Jun 25 at 12:06
See the documentation, especially the last part before “See Also”: learn.microsoft.com/en-us/office/vba/api/word.find — Timothy Rylatt
– Timothy Rylatt, Commented Jun 25 at 13:39
This question is similar to: How can I avoid using Select in Excel VBA?. If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. — June7
– June7, Commented Jun 25 at 15:33
If you successfully execute a Find call on range rng, then following that call rng is now set to the found text. You can use that to find out the end of the found text range and so the starting point for the text following the found range. Eg see learn.microsoft.com/en-us/office/vba/word/concepts/… — Tim Williams
– Tim Williams, Commented Jun 25 at 17:30

macropod · Accepted Answer · 2025-06-25 22:17:13Z

2

A trivial undertaking. For example:

Sub Demo()
With ActiveDocument.Range
  With .Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "Text to Find"
    .Replacement.Text = ""
    .MatchWildcards = False
    .Format = False
    .Forward = True
    .Wrap = wdFindStop
    .Execute
  End With
  If .Find.Found = True Then
    .End = ActiveDocument.Range.End
    MsgBox .Text
  End If
End With
End Sub

Given that you haven't shown us any of your code to automate Word, I haven't bothered with that side of things.

answered Jun 25 at 22:17

macropod

14k2 gold badges11 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

RJPWilliams Nov 8 at 13:33

Decided not to follow this one up and went about this a completely different way.

Collectives™ on Stack Overflow

MSAccess VBA Find Text in Word Document Select All Text After Find

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related