How do I open up power point in excel

Posted by Steve W on April 29, 2001 9:07 AM

Maybe someone can help,

I've posted this before but never got an answere exactly how I wanted it. I want to open powerpoint from excel have it run then exit powerpoint and return to excel. I've tryed hyperlinks embedding and some VBa code but none worked right, embedding closes the presentation but not powerpoint.

Thanks for any help you can provide.
Steve W

Posted by Ivan Moala on April 29, 2001 7:25 PM

Hi Steve just a quick example of how to reference
this via excel.
This example opens and runs a Microsoft PowerPoint presentation using Automation. You need to reference the msppt9 OLB file or the msppt8 OLN file.

Sub runPPt()
Dim ppt As PowerPoint.Presentation

Set ppt = GetObject("C:\My Documents\Feb01 Mgmt meeting.ppt")
ppt.SlideShowSettings.Run
ppt.Close

End Sub

HTH

Ivan