Export cells and chart from Excel to Ppt

**kryt0n** · 11-30-2011, 06:15 AM

Hi all,

I would like to know what the code would be to export cells and a chart from excel to powerpoint.

In a workbook on sheet1 I have a table, a chart and a table. I would like to be able to export them so that table1, chart1 and table2 appear on 3 separate ppt slides.

Is this possible and if so what code would be needed?

Thank you

**kryt0n** · 11-30-2011, 07:12 AM

Can anyone help?

**kryt0n** · 11-30-2011, 08:12 AM

Ok,

I've got it working so that I can get a chart onto a ppt:

Please Login or Register  to view this content.

Within the sheet I have 2 tables. Can I add named ranges to the code to copy each named range onto a different slide?

The sequence goes, Table1, Chart1, Table2

I want a ppt to open with Table1 on slide1, chart1 on slide2 etc

**kryt0n** · 11-30-2011, 08:52 AM

Please someone help!

**kryt0n** · 11-30-2011, 10:14 AM

Getting desperate guys. Can anyone point me in the right direction?

**Jon_Peltier** · 12-05-2011, 11:02 AM

Hint:

The same way you copied a chart and pasted it as a picture in a new PowerPoint slide, you can copy a range and paste it as a picture into another slide.