Copy/Paste

[James8309]

Hi Everyone,

I was wondering if it is possible for me to use VBA somehow to import
some data from an excel file.
i.e. Open up excel file and copy some data from particular sheets then
paste into word file on particular pages.

I tried to put some macros in excel VBA but it seems that excel VBA
does not recognize .doc file to begin with.

I have a really big excel file report and every month I have to copy &
paste each section in excel worksheet to word document to create a
hard report and as you can tell it is pain in the axx.

Can anyone help?

Thank you !

 

[Doug Robbins - Word MVP]

See the article "Control Word from Excel" at:

http://www.word.mvps.org/FAQs/InterDev/ControlWordFromXL.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