PDA

View Full Version : (VBA) error adding Title and Subtitle to PowerPoint Slide



Dimitris254
06-02-2016, 06:56 AM
Hi all,

i have a 2-3 cells in an Excel sheet, which i read as title and subtitle values for a Powerpoint slide.

The title is written without problem, but i get error for the subtitle.

Run-time error:

Placeholders.Item : Integer out of range. 2 is not in Index's valid range of 1 to 1

my code:

PP_Slide.Shapes.Placeholders.Item(1).TextFrame.TextRange.Text = "Test Title " & current_year

PP_Slide.Shapes.Placeholders.Item(2).TextFrame.TextRange.Text = mySheet.Cells(5, "A").Value
same error either with .Placeholders(2) or .Placeholders.Item(2).

mancubus
06-02-2016, 07:22 AM
i am sure you've seen this:
https://msdn.microsoft.com/en-us/library/office/ff744297.aspx


what goole gives is:

.Shapes(2)

Dimitris254
06-02-2016, 08:39 AM
i've seen that, yes, but what do you mean by .Shapes(2) ?

also, do mind that the slide already includes a shape (an image)