Excel chart to powerpoint linked chart - VBA

B

Ben

Hi
I just got around to trying this out and have come accross a few problems.
Firstly, how do I paste into powerpoint from VBA? I have something along
these lines, but it just pastes any text previously in the clipboard...

For Each nextChart In excelWookbook.Charts

nextChart.Copy
ActiveSheet.Copy

Set ppSlide = ppPresentation.Slides.Add(1, ppLayoutBlank)
ppSlide.Shapes.Paste
Next

Also, is it possible to do this with ChartObjects.Charts? Or can I convert
these to WoorkBook.Charts in VBA?

Thanks
Ben
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel to Powerpoint 2003 Chart Width 2
Charts from EXCEL into PPT with .POT 1
CopyPicture Colors to PowerPoint 1
Macros to Link Ranges and Charts from Excel 2007? 0
Problem Copying Charts to PowerPoint 3
Charts from Excel to Powerpoint 2
Excel linked charts in Powerpoint reverts to a single chart 5
Save chart with Excel worksheet in PowerPoint 2007 0

Top