Run between Excel and application.

[f1fan]

Hi All,

How do I create a script that would allow a slideshow to run and then after it had finished an aplication then would show for a set duration and then this process to repeat it self continously?

Not had zero/much experience in scripting. Sorry!

Be preety awesome if could get this working

Thanks.

[water]

Welcome to AuotIt and the forum!

"How do I create a script that would allow a slideshow to run and then after it had finished (use RunWait) an aplication then would show for a set duration (use RunWait) and then this process to repeat it self continously? (use While/WEnd)"

[f1fan]

Thank you!

Aaaa, yes it was easier then I thought it would be to create. Just set up the slideshow to go through the slides around 10 seconds and then time it with how many seconds that are on the script and then sorted left to run everyday hah.

Thanks!

[water]

Glad to be of service

[f1fan]

Actually, is there anything within the script that I could create so the other application will be brought up after the Slideshow has finished? and then repeats this.. At the moment, I'm just doing the slideshow on a timer and it's not working properly.

[water]

Can you post the code you have so far?

[f1fan]

While 1 ;loop indefinitely

WinActivate("PowerPoint Slide Show - [McLarenshopfloorPresentation]")

Sleep(30000) ;sleep 30 seconds

WinActivate("MaxTalk")

Sleep(30000) ;sleep 30 seconds

WEnd

[water]

You could have better control if you start the PowerPoint Slide Show from within your script. Is that possible?

Edited September 27, 2012 by water

[f1fan]

I have haven't I? I used the AutoIT tool to select the first slideof the slideshow and then copeid and pasted the name into the script. This then brings up the first page of the slideshow and then from here the automatic process from PowerPoiint then goes on untill 30 seconds when the new application starts.

[water]

I was thinking about something like:

While 1
    ShellexecuteWait("YourPowerPointPresentation.PPS")
    RunWait("another.exe")
WEnd

[f1fan]

I don't understand where I would put this? Sorry!

[water]

How do you start the PowerPoint presentation now?

[f1fan]

I open up the slideshow (on first slide) and then I bring up the Task Manager and then start the script.

[water]

This could by done by your script too. Then it is much easier to wait until the presentation has finished and to start the second program.

[f1fan]

huh? I don't understand. I don't mind opening up the slideshow this way and then starting the script (once I've done this, then it won't be touched again unless a problem occurs) Just want it so when the SlideShow finishes the other program loads up. Then when that's done, it goes back to the slideshow and so on...

[water]

That's exactly the problem. How do you determine that the presentation has finished when you start it manually?

If started by the script function ShellexecuteWait automatically returns to the script when the presentation has finished.

Therefore I suggest to start the presentation by the AutoIt script. You could even let the user select the presentation etc.

[f1fan]

Okay... where do I put that new bit of script into my existing script?

[water]

Replace

WinActivate("PowerPoint Slide Show - [McLarenshopfloorPresentation]")

with

ShellExecuteWait("yourpresentation.pps")

and remove the Sleep statements that follow,

[f1fan]

It says it cannot find the presentation....

While 1 ;loop indefinitely

ShellExecuteWait("McLarenshopfloorPresentation.pps")

WinActivate("MaxTalk")

WEnd

I've also tried

While 1 ;loop indefinitely

ShellExecuteWait("

PowerPoint Slide Show - [McLarenshopfloorPresentation]")

WinActivate("MaxTalk")

WEnd

[water]

Then you'll have to specify the while path to the presentation like "C:presentationsMcLarenshopfloorPresentation.pps"