Pasting Multiple Page Excel Graphs into Word

[matzos]

The subject pretty much says it all. I have survey results in Excel that I need to merge into a Word document the contains several other pages of result analysis. I have SEVERAL of them and I will be doing this several times a month.

I want to be able to copy all of the graphs from Excel (they are on one worksheet) and paste them into Word. Right now when I do that it only fills one page and the majority of the graph information is lost at the page break. Is there a way to extend the object beyond the page break or am I forced to only cut and Paste a couple graphs at a time per page?

There must be an option somewhere to allow this. PLEASE...let there be.

Thanks!

 

[PeterMoran]

Hi matzos,

Here is a URL which may be of use to you:

http://word.mvps.org/faqs/macrosvba/LinkTableWithGraph.htm

It is a great Word site.

Good Luck!
Peter Moran