#31
|
|||
|
|||
Exceeding the allowed number of characters in one line
Hi macropod,
Incredible thank you for this macro!!! I only discovered macros today and your initial macro works incredibly well for my purpose (highlighting the specific mentions of companies that I need to check for and report). Only since I have roughly 250 company names to check for in a single word doc, I exceed the StrFnd line symbol limit and the macro skips the preceding lines (connecting with " _ " didn't work of course). Is there a way to fix that (without having 3 separate macros)? I looked into your suggestion to have data pulled from excel sheet (https://www.msofficeforums.com/word-...d-replace.html), but since it's my very first macro, can't see how to work it into your original HiLightList macro. Thank you for sparking my interested in VBA and macros! Abigail |
#32
|
||||
|
||||
Quote:
Code:
StrFnd = "dog|cat|pig|horse|man|" & _ "dogs|cats|pigs|horses|men" Code:
StrFnd = "dog|cat|pig|horse|man|" StrFnd = StrFnd & "dogs|cats|pigs|horses|men" Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#33
|
|||
|
|||
Fantastic! Thank you for such a prompt response and all your help!
|
#34
|
|||
|
|||
Hey Macropod,
Thank you for this amazing code, it has saved me hours of work. I know it has been a while since your last response, but the code doesn't seem to identify words that are in headers, footers, and text boxes. I found that word documents are broken down into 17 stories. Mastering VBA for Microsoft Office 2013 - Richard Mansfield - Google Books What changes can be made in order for the macro to catch words in some or all of the stories? Thanks, Ariana |
#35
|
||||
|
||||
That's because the code was written only to process content in the document body. To process content in all StoryRanges, see, for example:
https://www.msofficeforums.com/90012-post4.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#36
|
|||
|
|||
Thank you very much!
|
#37
|
|||
|
|||
Thx for providing the macro and continued support. I've been looking to do this for a long time. The macro is just what I needed.
|
#38
|
|||
|
|||
The same macro doesn't work on a device, but works on another
Hey Macropod,
I found your macro, and I was struggling to make it to work on my device. Finally, I tested it on another device, and it worked. Then, I made the same steps on the first one and still not working. I checked all security settings, and they are the same. Any idea why the macro might still not work on my device? Thank you a lot! Later edit: I decided to record a random macro to see if it runs. I ran the new Macro, it worked and then ran the other macro and worked as well. Pretty strange, but finally solved. Thank you for providing this valuable code! |
Tags |
find, highlight, multiple keywords |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lost Word Document and cant find it!!! I saved it but it ISNT there!! | APAV | Word | 9 | 10-09-2017 01:17 PM |
Highlight text and find next instance | DrDOS | Word | 0 | 11-15-2010 04:02 PM |
Lock words in a document, but allow for input within the document | tlinde | Word | 1 | 02-09-2010 09:07 PM |
FInd recurring words in Word 2003 | NJ007 | Word | 4 | 01-25-2010 03:11 PM |
find - reading highlight - highlight all / highlight doesn't stick when saved | bobk544 | Word | 3 | 04-15-2009 03:31 PM |