Copy Chart from Excel to Word

[Jonathan Allen]

Using VBA, how do I copy an chart from Excel to a Word document?
I can already copy cells and place them at Word bookmarks.


--
Jonathan Allen

[Jon Quixley]

Jonathan,

Select the chart by clicking on it (you will see the balck boxes appear in each corner), Depress the SHIFT key and at the same time pull down EDIT/COPY PICTURE, select "As shown on screen" and "Bitmap". Open your Word file and place the I-bar where you want the chart to paste, click once and go to EDIT/PASTE (or right click and do the same thing) - Your chart is pasted as a picture.
Pasting as a dynamic chart is slightly different - select the chart, EDIT/COPY, EDIT/PASTE SPECIAL select Paste as a Chart Object and toggle the Paste button on.

Cheers