Need macro to fill the values in msword based on the excel sheet info

macropod · #37 08-28-2018, 09:18 PM

As I said, you can do it via Find/Replace. You could even record a macro for that!

Nevertheless, insert:

Code:

  With .Range.Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .MatchWildcards = True
    .Forward = True
    .Format = False
    .Wrap = wdFindContinue
    .Text = "(PV: )RR([0-9])"
    .Replacement.Text = "\1\2"
    .Execute wdReplaceAll
    .Text = "(PV:)RR([0-9])"
    .Replacement.Text = "\1 \2"
    .Execute wdReplaceAll
  End With

before the final 'End With' in the code you're already using.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need macro to fill data from different sheets based on selected item from drop down	skorasika	Excel Programming	1	03-13-2015 11:25 AM
Newbie to excel for starters, needing to transfer info from sheet2 to universe sheet.	rogcar75	Excel	0	08-12-2014 07:21 AM
Color-fill a range of cells, based on text in a different sheet. Possible?	unittwentyfive	Excel	2	06-01-2014 06:48 AM
link conditional info in word based on excel list	stijnvanhoof	Mail Merge	1	11-13-2012 01:55 PM
Open Word w Excel & fill Word textboxes w info from Excel fields runtime error 4248	Joe Patrick	Word VBA	2	01-30-2012 07:23 AM