Copy Chart from Excel to Word
 

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

Copy Chart from Excel to Word
 

Jonathan,

Select the chart by clicking on it (you will see the balck boxes appea
in each corner), Depress the SHIFT key and at the same time pull dow
EDIT/COPY PICTURE, select "As shown on screen" and "Bitmap". Open you
Word file and place the I-bar where you want the chart to paste, clic
once and go to EDIT/PASTE (or right click and do the same thing) - You
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 toggl
the Paste button on.

Cheer

--
Jon Quixle
-----------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...fo&userid=2580
View this thread: http://www.excelforum.com/showthread.php?threadid=56532