+ Reply to Thread
Results 1 to 1 of 1

Highlight certain words in Word document after running find-and-replace from Excel

  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    Seattle
    MS-Off Ver
    Excel 2003
    Posts
    3

    Highlight certain words in Word document after running find-and-replace from Excel

    So I'm relatively new to macros and have mostly constructed the one I'm using by downloading and tweaking it. It works great, but there's one more thing I'd like it to do that I'm having trouble with. Here's the code:

    Please Login or Register  to view this content.

    It opens a word document, finds all instances of a word from column A, and replaces them with whatever's in the corresponding row in column D. What I want it to do is also highlight specific words in the Word document that come from column D. These will be in the form of a number and the letter M (6m, 12m). I want it to highlight every time the number's over 12. So wherever it puts 12m, 13m, 14m, and so forth in the Word doc, I want it to be highlighted. I'd prefer if this happened as a function of the existing Excel macro as opposed to building a Word macro specifically for this purpose. Thoughts?
    Last edited by arlu1201; 10-22-2012 at 03:22 PM. Reason: Use code tags in future.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1