Producing charts from excel vba in Powerpoint

[KD]

Hi,

I am producing some data ranges in excel. What I
basically need is to be able to open PowerPoint, create a
new slide and then copy this data range on to the data
sheet using excel vba. On top of this I need another
cell's contents to be copied over from excel and included
as the chart title. Is there any way of achieving this
in vba?

KD

 

[Stephan Kassanke]

Hi,

I am producing some data ranges in excel. What I
basically need is to be able to open PowerPoint, create a
new slide and then copy this data range on to the data
sheet using excel vba. On top of this I need another
cell's contents to be copied over from excel and included
as the chart title. Is there any way of achieving this
in vba?

KD

KD,

you can achieve this by using a technique called automation

http://support.microsoft.com/default.aspx?scid=kb;EN-US;306682

and

http://www.vba-programmer.com/Excel_Code/Powerpoint_Automation.txt

should get you started.

cheers,
Stephan