I have created a code to export charts from Excel into a power point presentation. Each slide has three text boxes. Two of those text boxes are the same for each slide, but the content of one of them (the text box at the very top of the slide, which now has "Industry One" and "Industry Two") varies by slides.
I am wondering if there is a way to create a loop, where I can place the content/text of the text box("Industry One", "Industry Two", "Industry Three", etc.) in the Excel spreadsheet and then call for it in the code.

Also, is there a way to call for the private subs SlideTextBox and FormatPicture more efficiently? Right now, I have to call for them after each slide. Is there a way to do it once where it would work for all my slides?

I am copying a part of the code below, which would create 4 slides. The full presentation would have at least 20 slides, so I am looking to build a more efficient/flexible code.

Thanks for any ideas!!

Please Login or Register  to view this content.