Populating a Word doc table from Excel

[Peter T in Oz]

I want to poulate a Word doc table with data from Excel. The Excel data is
held in two adjacent 10 row columns (say A1:B10) where some Excel rows may be
empty.
First column contains text, the other a value.

Is it possible to create a two column table in Excel, that automatically
adjusts its size to the number of "occupied" data rows in Excel. i.e if there
are only three rows of excel data, there are three rows in the Word doc table.

Am new to VBA so any assistance with code would be much appreciated.

Cheers,

Peter

 

[Peter T in Oz]

Correction - should read "is it possible to create a two column table in
"Word" not "Excel"

 

[Kevin B]

Wouldn't it be easier to insert the file as a linked object?

Insert/Object on the Word menu then click the Create from File tab. Locate
the file and click on the Link check box.

 

[Peter T in Oz]

You're right - much easier, thanks Kevin

Peter

Wouldn't it be easier to insert the file as a linked object?

Insert/Object on the Word menu then click the Create from File tab. Locate
the file and click on the Link check box.