My objective is to create a PowerPoint presentation from Excel. I'm able to open the presentation and paste to existing slides, but am having trouble when I try to insert a new slide. Not having experience coding VBA in PowerPoint, I recorded the command to insert a slide, added the object to the front, and put it in my Excel VBA. Doesn't work. Does someone know what I am doing wrong?
I get Run-time error '429' ActiveX component can't create object.Set PPApp = GetObject(, "PowerPoint.Application") PPApp.Visible = True Set PPPres = PPApp.ActivePresentation PPApp.ActiveWindow.View.GotoSlide Index:=ActivePresentation.Slides.Add _(Index:=6, Layout:=ppLayoutTitleOnly).SlideIndex
Thank you in advance for all assistance.
Larrybud