[binar]

Ed,
Thanks for the help. I have a followup question regarding this approach you
are recommending. In EXCEL each cell is identified A1, A2, B1, B2, C1, etc...
In Word the cells in tables don't really have such reference designators. How
will a macro created in Excel accomplish the task of copying data from cells
A1:A4 and transfer it to the same cells located in a Word Table where such
reference designators are not used? I am not to clear on how the CntRows and
CntCols will accomplish this. Any info or links will be greatly appreciated.

"Ed from AZ" wrote:

Why wouldn't a link from the Excel worksheet range into the Word
document work?

If that just won't do, then you may have to resort to a brute-strength
method I have employed: as long as your Word table and your Excel
range are the same size, you could have a macro that scanned through
each cell one by one and wrote the data into Word:
For 1 To cntRows
For 1 To cntCols
WDtblcell(cntRows, cntCols) = XLcell(cntRows, cntCols)
Next
Next

Ed

On Mar 17, 2:14 pm, "Suzanne S. Barnhill" wrote:
Can you embed the Excel worksheet in your doc?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"binar" wrote in message

...



Fellow Forum Members,
I am using Word 2003 for a technical manual that has close to 300 pages of
tables containing parts data. This parts data is changing all of the time
due to engineering making changes all of the time. Updating these 300
pages
of data is a major pain. My thinking is I should manage all of this data
in
Excel and then perform a mail merge of some kind to update 300 pages
automatically. What is the best way to go about combining external data
into
Word? I would like each cell in my Word table to match every cell in the
my
Excel file one for one. What is the best function to use? Is there an
automated way to setup the cells in my Word tables so that each cell
matches
a cell in my Excel table? I would like to do this right, any help will be
greatly appreciated. Thanks.- Hide quoted text -

- Show quoted text -