Controlling PPT from within Access (Office 2007)

[Dale Fye]

I've figured out how (thanks to the Microsoft knowledgebase) to open a
PowerPoint application (or get the active one) from within Access. I've also
figured out how to view the slides in an Access form, and control which slide
is displayed in the PowerPoint design view from within Access.

What I need to figure out now is how to change the view of the presentation
from design view to slideshow view.

 

[Steve Rindsberg]

I've figured out how (thanks to the Microsoft knowledgebase) to open a
PowerPoint application (or get the active one) from within Access. I've also
figured out how to view the slides in an Access form, and control which slide
is displayed in the PowerPoint design view from within Access.

What I need to figure out now is how to change the view of the presentation
from design view to slideshow view.

Use the presentation's SlideShowSettings object to set slide show options:

With oPres.SlideShowSettings
.ShowType = ppShowTypeKiosk
.LoopUntilStopped = msoTrue
.ShowWithNarration = msoTrue
.ShowWithAnimation = msoTrue
.RangeType = ppShowAll
.AdvanceMode = ppSlideShowUseSlideTimings
.PointerColor.RGB = RGB(Red:=255, Green:=0, Blue:=0)
' then call the Run method to start the show:
.Run
End With

' to stop the show:
SlideShowWindows(Index:=1).View.Exit

 

[Dale Fye]

Thanks, Steve.

On the slideshow tab of the ribbon bar, there is an option to display the
slideshow on either the primary or secondary monitor. Any idea what the
appropriate object property is to change that between #1 and #2?

 

[Steve Rindsberg]

Thanks, Steve.

On the slideshow tab of the ribbon bar, there is an option to display the
slideshow on either the primary or secondary monitor. Any idea what the
appropriate object property is to change that between #1 and #2?

If memory serves, that's not exposed in the OM, but it's stored in the registry.