Macros ... Excel to PowerPoint

LaShark · Mar 18th, 2002, 10:39 AM

Anyone have a VBA trick to copy and paste a chart from excel into powerpoint as a picture. I am able to use the following command to paste a chart as an "excel chart object" into powerpoint: .ActiveWindow.View.Paste. However, my objective is to "paste special" as a picture or bitmap using macros.

LaShark · Mar 18th, 2002, 11:11 AM

Found something that works.

Use ActiveChart.CopyPicture rather than
ActiveChart.ChartArea.Copy. This copie the chart as a picture and removes the excel link.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 10:39 AM	#1
LaShark Join Date: Mar 2002 Posts: 9	Anyone have a VBA trick to copy and paste a chart from excel into powerpoint as a picture. I am able to use the following command to paste a chart as an "excel chart object" into powerpoint: .ActiveWindow.View.Paste. However, my objective is to "paste special" as a picture or bitmap using macros.

Mar 18th, 2002, 11:11 AM	#2
LaShark Join Date: Mar 2002 Posts: 9	Found something that works. Use ActiveChart.CopyPicture rather than ActiveChart.ChartArea.Copy. This copie the chart as a picture and removes the excel link.