View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kari J Keinonen[_2_] Kari J Keinonen[_2_] is offline
external usenet poster
 
Posts: 20
Default POWERPOINT IN EXCEL

Hi Glenn!

I think next code works.

Sub DrivePresentation()
Dim MyPowerPoint As Object
Dim MyPresentation As Object
Dim myPath As String

myPath = Application.ActiveWorkbook.Path
myPath = myPath & "\"
Application.ActivateMicrosoftApp xlMicrosoftPowerPoint
Set MyPowerPoint = CreateObject("PowerPoint.Application")
MyPowerPoint.Visible = True
Set MyPresentation = MyPowerPoint.presentations.Open(myPath & "Dias.ppt")
With MyPresentation.SlideShowSettings
.ShowType = ppShowTypeSpeaker
.Run
End With
End Sub

Regards
Kari J Keinonen