Open presentation in slideshow view, from Access via VBA

  • Follow


I've got an Access application I'm developing to control a Powerpoint 
presentation.

I've figured out how to open PPT, select a presentation, and view that 
presentation in design view, but have not figured out how to switch the view 
to SlideShow.  

Assuming I have application (oPPT) and presentation (oPres) objects,  what 
VBA do I need to change the view of PPT from design view to slideshow view.

----
Dale

0
Reply Utf 11/18/2009 2:56:03 PM

Hi dale
Does oPres.SlideShowSettings.Run do it?
-- 
john ATSIGN PPTAlchemy.co.uk

Free PPT Hints, Tips and Tutorials
http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html






"Dale Fye" wrote:

> I've got an Access application I'm developing to control a Powerpoint 
> presentation.
> 
> I've figured out how to open PPT, select a presentation, and view that 
> presentation in design view, but have not figured out how to switch the view 
> to SlideShow.  
> 
> Assuming I have application (oPPT) and presentation (oPres) objects,  what 
> VBA do I need to change the view of PPT from design view to slideshow view.
> 
> ----
> Dale
> 
0
Reply Utf 11/18/2009 3:13:02 PM


John,

Yes,  but now the line in my code which selects which slide to display in 
the design view (see below) is generating an error.

    oPres.Slides(mlngSlideIndex + 1).Select

Runtime error -2147188160 (80048240)
Slide (unknown member): invalid request. This view does not support selection

Which generates several new questions.

1.  How do I determine whether the presentation is showing in design or 
slide show view?

2.. How do I close the slideshow view?

3.  How do I manipulate the slide that is shown in the slideshow?

----
Dale



"John Wilson" wrote:

> Hi dale
> Does oPres.SlideShowSettings.Run do it?
> -- 
> john ATSIGN PPTAlchemy.co.uk
> 
> Free PPT Hints, Tips and Tutorials
> http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html
> 
> 
> 
> 
> 
> 
> "Dale Fye" wrote:
> 
> > I've got an Access application I'm developing to control a Powerpoint 
> > presentation.
> > 
> > I've figured out how to open PPT, select a presentation, and view that 
> > presentation in design view, but have not figured out how to switch the view 
> > to SlideShow.  
> > 
> > Assuming I have application (oPPT) and presentation (oPres) objects,  what 
> > VBA do I need to change the view of PPT from design view to slideshow view.
> > 
> > ----
> > Dale
> > 
0
Reply Utf 11/18/2009 4:52:01 PM

In article <4B0CF25D-FD05-4105-8FC9-812753EEDD14@microsoft.com>, Dale Fye 
wrote:
> I've got an Access application I'm developing to control a Powerpoint 
> presentation.
> 
> I've figured out how to open PPT, select a presentation, and view that 
> presentation in design view, but have not figured out how to switch the view 
> to SlideShow.  
> 
> Assuming I have application (oPPT) and presentation (oPres) objects,  what 
> VBA do I need to change the view of PPT from design view to slideshow view.

Replied to this elsewhere.


==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/


0
Reply Steve 11/18/2009 5:22:49 PM

OK, I figured out that I could create a SlideShowWindow object (oSSW) from 
the .Run command.  And when this error comes up, I've got an error handler 
that uses:

oSSW.view.gotoslide ##

But is there a more elegant way to determine this?

I still have not figured out how to close the SlideShowWindow via code.

----
Dale



"Dale Fye" wrote:

> John,
> 
> Yes,  but now the line in my code which selects which slide to display in 
> the design view (see below) is generating an error.
> 
>     oPres.Slides(mlngSlideIndex + 1).Select
> 
> Runtime error -2147188160 (80048240)
> Slide (unknown member): invalid request. This view does not support selection
> 
> Which generates several new questions.
> 
> 1.  How do I determine whether the presentation is showing in design or 
> slide show view?
> 
> 2.. How do I close the slideshow view?
> 
> 3.  How do I manipulate the slide that is shown in the slideshow?
> 
> ----
> Dale
> 
> 
> 
> "John Wilson" wrote:
> 
> > Hi dale
> > Does oPres.SlideShowSettings.Run do it?
> > -- 
> > john ATSIGN PPTAlchemy.co.uk
> > 
> > Free PPT Hints, Tips and Tutorials
> > http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html
> > 
> > 
> > 
> > 
> > 
> > 
> > "Dale Fye" wrote:
> > 
> > > I've got an Access application I'm developing to control a Powerpoint 
> > > presentation.
> > > 
> > > I've figured out how to open PPT, select a presentation, and view that 
> > > presentation in design view, but have not figured out how to switch the view 
> > > to SlideShow.  
> > > 
> > > Assuming I have application (oPPT) and presentation (oPres) objects,  what 
> > > VBA do I need to change the view of PPT from design view to slideshow view.
> > > 
> > > ----
> > > Dale
> > > 
0
Reply Utf 11/18/2009 5:36:02 PM

You cannot SELECT anything in slide show view

SlideShowWindows(1).View.Exit
SlideShowWindows(1).View.GotoSlide(x)
-- 
john ATSIGN PPTAlchemy.co.uk

Free PPT Hints, Tips and Tutorials
http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html






"Dale Fye" wrote:

> OK, I figured out that I could create a SlideShowWindow object (oSSW) from 
> the .Run command.  And when this error comes up, I've got an error handler 
> that uses:
> 
> oSSW.view.gotoslide ##
> 
> But is there a more elegant way to determine this?
> 
> I still have not figured out how to close the SlideShowWindow via code.
> 
> ----
> Dale
> 
> 
> 
> "Dale Fye" wrote:
> 
> > John,
> > 
> > Yes,  but now the line in my code which selects which slide to display in 
> > the design view (see below) is generating an error.
> > 
> >     oPres.Slides(mlngSlideIndex + 1).Select
> > 
> > Runtime error -2147188160 (80048240)
> > Slide (unknown member): invalid request. This view does not support selection
> > 
> > Which generates several new questions.
> > 
> > 1.  How do I determine whether the presentation is showing in design or 
> > slide show view?
> > 
> > 2.. How do I close the slideshow view?
> > 
> > 3.  How do I manipulate the slide that is shown in the slideshow?
> > 
> > ----
> > Dale
> > 
> > 
> > 
> > "John Wilson" wrote:
> > 
> > > Hi dale
> > > Does oPres.SlideShowSettings.Run do it?
> > > -- 
> > > john ATSIGN PPTAlchemy.co.uk
> > > 
> > > Free PPT Hints, Tips and Tutorials
> > > http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > "Dale Fye" wrote:
> > > 
> > > > I've got an Access application I'm developing to control a Powerpoint 
> > > > presentation.
> > > > 
> > > > I've figured out how to open PPT, select a presentation, and view that 
> > > > presentation in design view, but have not figured out how to switch the view 
> > > > to SlideShow.  
> > > > 
> > > > Assuming I have application (oPPT) and presentation (oPres) objects,  what 
> > > > VBA do I need to change the view of PPT from design view to slideshow view.
> > > > 
> > > > ----
> > > > Dale
> > > > 
0
Reply Utf 11/18/2009 5:56:03 PM

Thanks, John

----
HTH
Dale



"John Wilson" wrote:

> You cannot SELECT anything in slide show view
> 
> SlideShowWindows(1).View.Exit
> SlideShowWindows(1).View.GotoSlide(x)
> -- 
> john ATSIGN PPTAlchemy.co.uk
> 
> Free PPT Hints, Tips and Tutorials
> http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html
> 
> 
> 
> 
> 
> 
> "Dale Fye" wrote:
> 
> > OK, I figured out that I could create a SlideShowWindow object (oSSW) from 
> > the .Run command.  And when this error comes up, I've got an error handler 
> > that uses:
> > 
> > oSSW.view.gotoslide ##
> > 
> > But is there a more elegant way to determine this?
> > 
> > I still have not figured out how to close the SlideShowWindow via code.
> > 
> > ----
> > Dale
> > 
> > 
> > 
> > "Dale Fye" wrote:
> > 
> > > John,
> > > 
> > > Yes,  but now the line in my code which selects which slide to display in 
> > > the design view (see below) is generating an error.
> > > 
> > >     oPres.Slides(mlngSlideIndex + 1).Select
> > > 
> > > Runtime error -2147188160 (80048240)
> > > Slide (unknown member): invalid request. This view does not support selection
> > > 
> > > Which generates several new questions.
> > > 
> > > 1.  How do I determine whether the presentation is showing in design or 
> > > slide show view?
> > > 
> > > 2.. How do I close the slideshow view?
> > > 
> > > 3.  How do I manipulate the slide that is shown in the slideshow?
> > > 
> > > ----
> > > Dale
> > > 
> > > 
> > > 
> > > "John Wilson" wrote:
> > > 
> > > > Hi dale
> > > > Does oPres.SlideShowSettings.Run do it?
> > > > -- 
> > > > john ATSIGN PPTAlchemy.co.uk
> > > > 
> > > > Free PPT Hints, Tips and Tutorials
> > > > http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > "Dale Fye" wrote:
> > > > 
> > > > > I've got an Access application I'm developing to control a Powerpoint 
> > > > > presentation.
> > > > > 
> > > > > I've figured out how to open PPT, select a presentation, and view that 
> > > > > presentation in design view, but have not figured out how to switch the view 
> > > > > to SlideShow.  
> > > > > 
> > > > > Assuming I have application (oPPT) and presentation (oPres) objects,  what 
> > > > > VBA do I need to change the view of PPT from design view to slideshow view.
> > > > > 
> > > > > ----
> > > > > Dale
> > > > > 
0
Reply Utf 11/18/2009 10:13:02 PM

6 Replies
479 Views

(page loaded in 0.087 seconds)

Similiar Articles:
















7/25/2012 11:42:11 AM


Reply: