+ Reply to Thread
Results 1 to 4 of 4

Need a macro to find and replace words in word using excel column 1(find) column (replace)

  1. #1
    Registered User
    Join Date
    11-24-2014
    Location
    india
    MS-Off Ver
    2003
    Posts
    4

    Need a macro to find and replace words in word using excel column 1(find) column (replace)

    Hi,

    Please help in creating a macro for bulk replacing the data for below mentioned details.

    Excel - This excel has data in column A and B which consists of data find and replace (approximately 50 entries)

    Word - Word has data which has be corrected accordingly using Excel's find and replace entries.

    Please help me to create a macro.

    VBA helps to complete the work faster.


    Thanks in advance.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,679

    Re: Need a macro to find and replace words in word using excel column 1(find) column (repl

    Why don't you keep that Find Words of Winword in Excel Sheet itself?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    11-24-2014
    Location
    india
    MS-Off Ver
    2003
    Posts
    4

    Re: Need a macro to find and replace words in word using excel column 1(find) column (repl

    need a batch a macro for batch word find and replacement using excel

  4. #4
    Registered User
    Join Date
    11-24-2014
    Location
    india
    MS-Off Ver
    2003
    Posts
    4

    Re: Need a macro to find and replace words in word using excel column 1(find) column (repl

    Hi,

    Please help in creating a macro for bulk find and replacement of words in word using excel sheet entries.

    i mean like entering values in excel
    Excel - columns
    A1(fIND) B1(REPLACE)
    ugly lazy
    Cat dog

    in every instances of msword having content

    "The ugly cat was given milk" -- before applying macro

    "The lazy dog was given milk" -- after applying macro

    This is just an example of two word replacement, but need a macro for multiple word replacement.

    Can u please help me out.

    Thanks in advance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlight certain words in Word document after running find-and-replace from Excel
    By EnterTheSerpent in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2012, 02:27 PM
  2. find in excel replace in word: find/replace text in text boxes and headers
    By dean.rogers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2012, 12:40 PM
  3. Replies: 2
    Last Post: 04-29-2011, 10:53 AM
  4. Find multiple words and replace the adjacent column with one word
    By ic3cold in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-13-2011, 05:04 PM
  5. [SOLVED] Find/Replace macro from excel into Word
    By Matt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2006, 11:40 AM

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