You would need to use visual basic to access each workbook and copy the data
from the range and paste it into the Word document, then close that workbook
and then move onto the next one and repeat the process.

See the article "Control Excel from Word” at:

http://www.word.mvps.org/FAQs/InterD...XLFromWord.htm

Starting with either a list of the workbooks or if all of the workbooks were
in a folder by themselves, it could all be automated.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Aardvark" wrote in message
...
I have data in a worksheet cell range (say A1:A10 for argument's sake -
and
it's NOT a list). This is replicated over numerous workbooks, all with
different names. I want to produce a report (.doc) containing the values
from
cells A1:A10 from workbook 'A', then on the next line down in the report,
I
want the contents of cells A1:A10 from workbook 'B', then on the next line
down in the report, the contents of cells A1:A10 from workbook 'C', and
so
on. This is to be automated somehow (suggestions welcome!!), so a number
of
workbooks can be selected, either graphically or progammatically, and the
process will take the data from each workbook in turn, and place it in the
report, as detailed above.
This is a little like a Mail Merge, but the data is not contained in a
list
(The rows of data in A1:A10 have no headings), and the data comes from
multiple workbooks instead of just one.
If it isn't possible to do this as described, is it possible to read the
data from the separate workbooks into a list in a single worksheet, and
then
do the equivalent of a mail merge into the report?
Maybe there's a piece of 3rd Party software that will do the above???!!!

Regards,
KG