Automate Pasting Charts from Excel to Word

G

GH

I have some data in Excel which I use to generate charts that are eventually
pasted into Word documents. To avoid the tedium of creating 425 separate
charts and pasting those charts into 85 different Word documents, I'd like to
automate the process.

I think I can create a macro in Excel to create each chart. However, I'm
stuck on how to take those charts, copy them and paste them into a specific
point in a Word document. Can I generate code in Excel's macro editor that
will instruct Excel to open a Word file and paste a copied chart?

If you can point me in the right direction, it would be appreciated.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move Chart with Text 0
Embed the same Excel multiple times 0
Doughnut Chart linked with the slicer in the pivot table 0
Template for pasting charts with caption 0
Auto Merge text from multiple sources 0
Excel --> Word 4
Why do charts disappear? 3
Setting column width in a table with a macro is not working 0

Top