Dimitris254
Board Regular
- Joined
- Apr 25, 2016
- Messages
- 139
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.
my code:
same error either with .Placeholders(2) or .Placeholders.Item(2).
PS: posted over vbaexpress too (no solution)
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:
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
PS: posted over vbaexpress too (no solution)