create macro in word using excel data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ann - 29 May 2008 22:07 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 30 May 2008 01:32 GMT

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

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

Signature

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

> 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
[quoted text clipped - 5 lines]
> so i was trying to automate it rather than copy/pasting it all the time.
> thanks.

Reply to this Message