Ignore registered and trademark symbols when executing a find in Word from Excel

Hi fellow coders...

I've written some code to take a column of keywords (comprising one or more words) and highlight all occurrences in a Word document that I open by creating a Word object. The code successfully opens the file and finds the keywords if they are an exact match. The issue is that some of the keywords in the Word doc include IP-related names, so if the keyword is, e.g. Fisher Price toy, the term Fisher Price® toy in the Word doc would not be picked up.

The .IgnorePunct property only matches if the only difference is something like a full colon (which makes sense). I've experimented with the .MatchFuzzy properties, but the one I thought would work (.MatchFuzzyWord) returns a "Runtime Error 438: Object doesn't support this property or method". Is this an issue because I'm calling it from Excel?

I would also like to catch singular vs plural differences, as the current properties aren't doing that, e.g. keyword=Fisher Price toy, Word doc=Fisher Prices toys

I have added the Word reference library.


Here's the part of my code with the .Find properties...

Please Login or Register  to view this content.

Looking forward to being enlightened

Have you tried .MatchWholeWord = False ?

If that doesn't give satisfactory results you could:
1. create a sheet that has search name variations.
2. when you bring in data, run a routine that removes all the unwanted characters.

Hope this helps.

You could use code along the lines of:

Please Login or Register  to view this content.

This will match strings that may or may not include registered marks, trade-marks, & copyright symbols.

With the previous code, insert:

Please Login or Register  to view this content.

after:

Please Login or Register  to view this content.

How about posting the code? It's pretty hard to tell you how to revise it when we can't see it.