Run between Excel and application.

[f1fan]

Okay... getting there. It brings up the presentation. But now it brings up just the screen with "rehearse timings" and not the slideshow.

While 1 ;loop indefinitely

ShellExecuteWait("C:testMcLarenshopfloorPresentation1.ppt")

WinActivate("MaxTalk")

WEnd

Edited September 27, 2012 by f1fan

[water]

You have saved the ppt file as well as a pps (self contained presentation), right?

[f1fan]

Aaaa yes. Sorry I've got that working now.... Now the problem is when the PowerPoint finishes the other application doesnt load up and the Powerpoint just carries on...

While 1 ;loop indefinitely

ShellExecuteWait("C:testMcLarenshopfloorPresentation1.ppt")

WinActivate("MaxTalk")

WEnd

[water]

As your code above shows you still call the PPT. Open the PPT, set tzhe presentation properties so the presentation runs only once and then exits, save it as PPS.

Call this PPS in your script.

This way when the presentation has finished ShellExecuteWait ends and the next statement can be executed.

[f1fan]

I've done this, and came back with file cannot be found... I save it as a PPS (Powerpoint Slide Show) added the PPS onto the script... also configured so would exit after 1 show of the slideshow...

While 1 ;loop indefinitely

ShellExecuteWait("C:testMMcLarenshopfloorPresentation1.pps")

WinActivate("MaxTalk")

WEnd

[water]

Isn't this a typo:

"C:testMMcLarenshopfloorPresentation1.pps"

[f1fan]

Ooops. Yeh sorry about that! So it runs..to the end of the slideshow and then it ends.

While 1 ;loop indefinitely

ShellExecuteWait("C:testMcLarenshopfloorPresentation1.pps")

WinActivate("MaxTalk")

WEnd

[water]

Does this mean that all problems are solved now?

[f1fan]

Sorry, I should of been more informative. The first part is fine, but it doesn't load up the 2nd application... and thus the continous loop doesn't happen....

[water]

I would suggest the same approach as with the PowerPoint presentation - start the application from within the loop.

[f1fan]

What do you mean? Sorry, I had no experience with scripting before.. if could show me an example, be real helpful. Thanks

[water]

How do you start the application you want to activate with

WinActivate("MaxTalk")

right now?

Edited September 28, 2012 by water

[f1fan]

The current script....

"While 1 ;loop indefinitely

ShellExecuteWait("C:testMcLarenshopfloorPresentation1.pps")

WinActivate("MaxTalk")

WEnd"

[water]

I mean: With "WinActivate" you try to activate an already running application. How do you start this application?

[f1fan]

When I run the script, it brings up the presentation runs that and just stays on the "end of slideshow, press exit".

I've tried opening the other application so it's there on the screen, but it still doesn't go to the other application and it just runs the presentation...

[water]

Looks like a configuration problem with PowerPoint. I'm no PowerPoint guru but I think it should be possible to end the presentation without the need to click a button.

[water]

To automatically exit you deactivate an option. Taken from Google:

"It's actually a PowerPoint option (weird that they set this as the default!). To turn it off:

Open PowerPoint and go to Tools > Options > View > SlideShow and click off all three options. This will eliminate the right clicking/popup issue as well as eliminate the "end of slide show" screen."

[f1fan]

Yup. I did all this... still same problem

[water]

Which version of PowerPoint do you run?

[f1fan]

2003.