View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stephan Kassanke Stephan Kassanke is offline
external usenet poster
 
Posts: 19
Default Producing charts from excel vba in Powerpoint


"KD" schrieb im Newsbeitrag
...
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...b;EN-US;306682

and

http://www.vba-programmer.com/Excel_...Automation.txt

should get you started.

cheers,
Stephan