Need Excel to pull data from a Word document

Hi Noir,

Yes, this can be done using Automation. There are several examples in the VBA helps. I would recommend that if your table in Word is columnar as your describe that you put it into a Word table rather than formatting it in columns using tabs. You can turn all the table lines off so that the fact that it is a table is not apparent. Having the data in a table enables you to easily find the data you want from Excel, since now the table is a Table object and can be referred to as, for example, Tables(1). In addition the cells of the table can be addressed by row and column (e.g., Tables(1).Cell(1,3) for row 1, column 3). Once you find the Word table cell you want to paste into Excel, pasting it in place is simple, e.g.:

[B4] = appWd.ActiveDocument.Tables(1).Cell(1,3).Range.Text

to put the text into the activesheet's cell B4.

The data can be found without using a table, but it is a bit more difficult.

I hope this helps.

Damon

Thanks Damon (NT)