I am attempting to create an Access database that will populate table fields
based on the search results of current and potential employee resumes. For
example, capturing X # of characters either side of words like "Master's
Degree", or "Military." I already have a similar question out to the Access
group, but started thinking that this would probably need to be a two step
process, starting with seaching a Word or RTF document, somehow saving the
results as *.txt and then importing that into Access.
Helmut Weber - 28 Jul 2005 18:19 GMT
Hi,
like this:
Dim rDcm As Range ' document's range
Dim rTmp As Range ' a temporary range
Set rDcm = ActiveDocument.Range
Set rTmp = ActiveDocument.Range
With rDcm.Find
.Text = "pro"
While .Execute
rTmp.Start = rDcm.Start - 5
rTmp.End = rDcm.End + 5
MsgBox rTmp
Wend
End With
Greetings from Bavaria, Germany
Helmut Weber, MVP, WordVBA
Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"
ThePolymathicMonk - 28 Jul 2005 18:30 GMT
Mr. (or should I say Herr?) Weber,
Thank you for the prompt reply...I will definately give that a try...
Sincerely,
KMN
> Hi,
>
[quoted text clipped - 19 lines]
> Win XP, Office 2003
> "red.sys" & Chr$(64) & "t-online.de"