create macro in word using excel data

[Ann]

i've been told i can't create a macro in word referencing excel data. is
there a way to do this? i have a table in word, and i want to create a macro
to go to a particular excel spreadsheet, copy the cells and paste them into
word. they will always be the same ss and the same cells. its a few tables
so i was trying to automate it rather than copy/pasting it all the time.
thanks.

 

[Doug Robbins - Word MVP]

The method that you need to use is similar to that in the article at:

http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm

--
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