Little bit of VBA

  • Thread starter Thread starter Gandalf Baggins
  • Start date Start date
G

Gandalf Baggins

Confession - I only use Windows @ work, so I've forgotten most of what I
know. At home I'm a Linux guy. Please overlook this. Once upon a time I
could write VBA for PowerPoint, but when I tried to solve a simple problem
for a colleague yesterday I failed. The new things I have learned have
pushed the old ones I used to know out of my head. Here is the problem:

Running PPT2000 under XP Pro, he has two presentations, both with a sound
track. He needs to be able to seamlessly stop the first and start the
second, from within the first. It looks like a job for a simple macro -
close the active presentation and start the next. But that doesn't work
because when the active presentation stops so does the macro. So do it
the other way round, start the second and while it's loading, stop the
first. But I couldn't make that work either.

Can anyone please show me what to do? I'll then pass it on to my
colleague and go back to Linux pastures and not bother you again.

Gandalf
 
On Thu, 22 Nov 2007 18:54:53 +0530, Chirag wrote:

Thanks, but If the presentations are linked the first one remains open and
it's audio is still playing! That was the first thing we tried. So we
have to close it when the second one starts. I should have mentioned.
 
Here is a VBA macro for starting the second slide show, assuming its named
2.ppt and is already open in PowerPoint:

Sub StartSecond()
Dim SecondPres As Presentation

Set SecondPres = Presentations("2.ppt")
SecondPres.SlideShowSettings.Run
SlideShowWindows(2).View.Exit
SlideShowWindows(1).Activate
End Sub

The macro would also close previously running slide show.

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html
 
Running PPT2000 under XP Pro, he has two presentations, both with a sound
track. He needs to be able to seamlessly stop the first and start the
second, from within the first. It looks like a job for a simple macro -
close the active presentation and start the next. But that doesn't work
because when the active presentation stops so does the macro. So do it
the other way round, start the second and while it's loading, stop the
first. But I couldn't make that work either.
Click to expand...

Here's a thought:

Create a small "intro/menu" presentation with a "Start the show" button that
triggers the macro (contained IN this presentation). The macro triggers the
first presentation, a button in the first presentation fires up the second,
then closes itself.
 
Here's a thought:

Create a small "intro/menu" presentation with a "Start the show" button that
triggers the macro (contained IN this presentation). The macro triggers the
first presentation, a button in the first presentation fires up the second,
then closes itself.
Click to expand...

Thanks guys. Much appreciated.
 
Back
Top