Hi everyone
Im trying to navigate back and forth between an xl document and a ppt presentation via VBA (Excel). Here is what Ive tried so far:
Sub ActivatePresentation()
' PowerPoint
Dim PPApp As PowerPoint.Application
Dim PPPres As PowerPoint.Presentation
Set PPApp = CreateObject("Powerpoint.Application")
Set PPPres = PPApp.Presentations.Open("MyPath.pptm")
PPApp.Visible = True
'Excel
Dim XLControlSheet As Workbook
Set XLControlSheet = ActiveWorkbook
'Navigate back and forth
XLControlSheet.Activate
PPPres.Activate
End Sub
Any suggestions?
many thanks!
Jon
Bookmarks