+ Reply to Thread
Results 1 to 3 of 3

Find in Excel and Replace in Word

  1. #1
    Registered User
    Join Date
    02-02-2010
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    62

    Question Find in Excel and Replace in Word

    Hi,

    I have a list of more than 500 words list in excel workbook, and i have a word document which contains summary of certain procedures (basically in paraghraphs).

    I need to find each word in word document with excel words list and replace it with these format italic, blue, underlined. But i want VBA to find the wholeword, not finding a partial word in any string that contains that word. Ex: "Rate" in excel word list and "moderate" in word document, code should not find like this Moderate.

    Please help me on this.

    All your help will be much appreciated

    Thanks

  2. #2
    Registered User
    Join Date
    02-02-2010
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    62

    Re: Find in Excel and Replace in Word

    Can anyone pls help me on this......

  3. #3
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,579

    Re: Find in Excel and Replace in Word

    You could use code like:
    Please Login or Register  to view this content.
    You will need to provide your own variables for StrWkBkNm and StrWkSht.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ 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