You failed to see the requisite. Must use existing word document.

I already know how to paste an excel table into word. All I want to do
is paste excel data into an *existing* word document.

I will simply have to construct the entire Word document in Excel if
there is no way to pass the data over.

At that point, (recreating the entire document) the word document would
no longer be needed.

Getting them to incorporate it at work is a different story, however.



On Thu, 10 Dec 2009 20:56:57 -0800 (PST), marcus
wrote:

Hi

Rather than using vb to bring the data in where the formatting can be
no always reliable (particualarily the curning of the words). Why not
use a link between XL and Word. Copy your table in XL, now open your
word document in the place the cursor where you want your table.

Goto Edit - PasteSpecial -

On the form select - Microsoft Office Excel Worksheet Object

Click the Paste Link radio button.

Now when ever your XL sheet changes so will your Word document change
to reflect the changes in XL.

Take care

Marcus