Add slide in Powerpoint via Excel

hi guys. via excel, i open a powerpoint template inside my com (named PptTemplate.pptx) and transfer the values of column A & B to the slides. this is my current code:

Please Login or Register  to view this content.

my question is how do i add slides based on the variable rows in my excel file? the slides must also be of the same design of my current slides. tried the code below but i got an error run-time error 429

Hi benishiryo,

Thanks for all the help your posts have given me over the years. I didn't try your code. I modified existing code that I had.

Try the following Macro which:
a. Opens the PowerPoint file.
b. Puts Text in the first 2 TextBoxes of Existing Slides until data runs out.
c. If there are not enough slides, the last slide is duplicated as required.
d. If there are too many slides, the extras are deleted.
e. Saves and closes the PowerPoint file.

Please Login or Register  to view this content.

Lewis

The following added Nov 25, 2015:
For anyone wanting to try this out with minimal effort, I am adding the following files in the .zip file attachment:
a. ExcelForumPutTextInPowerPointSlides.xls
b. ExcelForumPutTextInPowerPointSlides.ppt

Links to PowerPoint automation references:
http://www.globaliconnect.com/excel/...=79&Itemid=475
http://www.mahipalreddy.com/vba/ppvba.htm
http://peltiertech.com/Excel/XL_PPT.html

hi LJMetzger. glad to know that my posts have helped you before~ and now you are helping me! was initially worried i wouldn't understand from your code since you didn't add on to mine, but the comments you placed inside were extremely helpful. works brilliantly. thank you!
=)