Thread: Operating Word from Excel

Hi,

I would like to:
1. find a name (in my case a fund name) from an array in excel,
2. open a specific word doc,
3. find the fund name,
4. copy a couple of paragraphs under it, and
5. paste into a powerpoint document.

I'm running my VB code in excel. I've done 1, 2 and 3 (partially)

Here is what I have so far for the 4th point

Code:

    WordApp.Activate
      With WordApp.ActiveDocument.Content.Duplicate
        .Find.Execute Findtext:="FundA"
        .Copy
        .Font.Italic = True
    End With

but it only finds the fund name and selects that. Is there anyway I can do some kind of offset for word??

Thanks in advance!

S M

any ideas anyone?