Solved

Using the Find/Restrict method with wildcard characters

Posted on 1998-08-31
1
981 Views
Last Modified: 2008-02-01
Is it possible to use wildcard characters with the Find or Restrict methods using VBA from Word 97. It seems that =,>,<,<>,>=,<=,And,Or and Not are the only operators available. If thats the case how do you look up all the people with "Smith" in their name ex. Smithson,Blacksmith or just plain Smith?
0
Comment
Question by:harry526000
1 Comment
 
LVL 1

Accepted Solution

by:
drepetto earned 100 total points
Comment Utility
Word searches accepts wildcards.

Here you got an example

 Selection.Find.ClearFormatting
    With Selection.Find
        .Text = "as*we"
        .Replacement.Text = ""
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchWildcards = True
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With
    Selection.Find.Execute
    Selection.Find.Execute
End Sub

Hope this responded all your questions.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Create high volume marketing opportunities using email signatures with these top 10 DOs and DON'Ts of email signature marketing.
Outlook Free & Paid Tools
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now