How to access embedded excel in powerpoint

P

Patrick

I have a PowerPoint automation tool that will add a new slide and place an
Embedded Microsoft Excel Chart object on the slide. Once I have it how do I
access the object so that I can change the data on the second worksheet,
change the chart type, title, ...

Here is the VB .Net code I have to create the Excel Chart:


oApp.ActiveWindow.View.GotoSlide(Index:=oApp.ActivePresentation.Slides.Add(Index:=2, Layout:=PowerPoint.PpSlideLayout.ppLayoutText).SlideIndex)
oApp.ActiveWindow.Selection.SlideRange.Layout =
PowerPoint.PpSlideLayout.ppLayoutTitleOnly
oApp.ActiveWindow.Selection.SlideRange.Shapes.AddOLEObject(Left:=120,
Top:=110, Width:=480, Height:=320, ClassName:="Excel.Chart.8",
Link:=1).Select()
oApp.ActiveWindow.Selection.Unselect()
 

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

How to Import Formatted text as new Slides in PowerPoint 0
VBA - (re-) Set a Table Style 2
How to render HTML inside a Powerpoint slide through VBA 0
Embedded Excel worksheet's size changed after double-clicking in P 0
Find Embedded chart excel objects 0
Insert excel sheet in a powerpoint presentation 3
Blank charts in PowerPoint 2007 and Word 2007 after quiting Excel 0
Controlling the Windows Media Player in a Powerpoint Slide 0

Top