PC Review


Reply
Thread Tools Rate Thread

Automate Pasting Charts from Excel to Word

 
 
GH
Guest
Posts: n/a
 
      5th Aug 2008
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Special pasting Charts from Excel to Word (2007 versions) JK012 Microsoft Excel Charting 0 5th Nov 2009 03:06 PM
Pasting excel charts into word as bitmaps RWright Microsoft Excel Misc 2 4th Feb 2009 06:53 PM
Pasting Links from Charts in Excel to Word results in duplicates H =?Utf-8?B?Q2l0eUdpcmw=?= Microsoft Word Document Management 3 16th May 2007 03:31 PM
Pasting charts to Word from Excel as picture Hari Microsoft Excel Charting 5 5th Jul 2006 08:04 PM
Pasting Excel charts into Word =?Utf-8?B?VGhlcmVzYQ==?= Microsoft Excel Charting 4 27th Jan 2006 03:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:20 AM.