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

macropod · #1 08-27-2018, 10:04 PM

See post #42!!!

ganesang · #2 08-28-2018, 09:10 PM

Hi Paul

I can understand your situation.

I am close to complete this task except this fix. I know this is also another new instance which i found inconsistency in this task.

If you provide the suggestion for this will helpful for me....

The only think we have to do "PV: RR" to insert after without deleting the exist texts in the cell to "PV: [point value]"

Thanks
ganesang

macropod · #3 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.

ganesang · #4 08-28-2018, 09:22 PM

Thanks Much Paul!!! for you big help on this

ganesang · #5 08-28-2018, 10:07 PM

Hi Paul

I just wanted to check that,

Is there any possible to call the other function called as like "Sub QID(ByVal Control As IRibbonControl)" in this macro?

I am trying to call the above macro but having the error.

ganesang · #6 08-29-2018, 12:53 AM

Thanks Paul

I got the answer on this question!!!!

thanks much again for your big help

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