View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Rowan Drummond[_3_] Rowan Drummond[_3_] is offline
external usenet poster
 
Posts: 414
Default Opening Powerpoint file from Excel

Hi Jake

If you set a reference to the Microsoft Powerpoint Object Library then
you could try it like this:

Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)

If Range("A1").Value 10 Then

Dim ppApp As PowerPoint.Presentation

Set ppApp = GetObject("C:\temp\pptShow.pps")
ppApp.SlideShowSettings.Run

End If
End Sub

Hope this helps
Rowan

JakeyC wrote:
Yes, I'd like it to start the show. I realise my '.ppt' extension was
misleading - the one I used in the end was '.pps', however both seem to
launch an empty powerpoint.