Quick Import Excel Chart to Word?

[Matt]

Is there a quick way to input Excel charts into a word
document? I have 540 charts that I need to have in an
appendix of a document.

I'm opening to any suggestions that you may have. One
thought that I had is to create a VBA script to
essentially do a copy and paste 540 times. But, I have a
feeling there is an easier and/or faster way to get the
job done.

Thanks in advance for your help.

-Matt

 

[Matt]

Thanks Jon. Your website appears to be just what the
doctor ordered. Copying charts as pictures seem to have
some nice advantages over OLE objects.

-Matt

 

[Jon Peltier]

File size, for one. Pesky broken links, for another.

Glad it helped.

- Jon