Hi, this is my very first post, so please be gentle....
I have an Excel macro which opens a Powerpoint Slideshow (ppsx) with the filename VideoName, and closes and return to Excel after a given time (called Delay). This works well, but I need to open a specific, but varying from instance to instance, slide number. Can anyone help me with some code for that?
Sub ViewVideo()
Dim PPApp As Object
Set PPApp = CreateObject("Powerpoint.Application")
PPApp.Visible = True
PPApp.Presentations.Open ThisWorkbook.Path & VideoName
Application.Wait (Now + TimeValue(Delay))
PPApp.Quit
Application.WindowState = xlMaximized
End Sub
Bookmarks