Sometimes we need to control PowerPoint from excel. We may need to create or edit a PowerPoint presentation with excel sheet data. Or we may need to create several PowerPoint files using an Excel database and a PowerPoint template. So if you want to develop an Excel application which has this kind of requirement, first thing you need to do is finding the names of each objects within the PowerPoint presentation. So in this post I will explain how to find the name of any object within a PowerPoint presentation.
First, open your presentation.
Click on any object you want to find the name of. Then format tab will appear like this.
Now go to the “Format” tab. And click on the “Selection Pane” in the “Arrange” group.
When you click on the “Selection Pane”, Selection pane will appear right side of the PowerPoint Application.
Then you can find name of each object of current slide from that selection pane. In this example, names of objects are “Subtitle 2” and “Title 1”. And as I have selected the title in the slide, “Title 1” is highlighted in the “Selection pane”. This way you can find the name of any object in your slide.
Here is another example slide of that same PowerPoint presentation.
As you can see, this slide also has an object with name “Title 1”. So you can have objects with same name in different slides. Due to this reason we can’t reference objects only by their names. So we need to use slide number as well. See following example.
|
Dim oPPTApp As PowerPoint.Application Dim oPPTFile As PowerPoint.Presentation Set oPPTApp = CreateObject("PowerPoint.Application") oPPTApp.Visible = msoTrue DestinationPPT = "Path of the presentation here" Set oPPTFile = oPPTApp.Presentations.Open(FileName:=DestinationPPT) oPPTFile.Slides(1).Shapes("Title 1").TextFrame.TextRange.Text = "Slide 1 heading" oPPTFile.Slides(2).Shapes("Title 1").TextFrame.TextRange.Text = "Slide 2 heading" |
Also, using this method you can find names of other types of objects as well. Here is an example slide with an image.
