Sign in to follow this  
Followers 0
f1fan

Run between Excel and application.

58 posts in this topic

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.

Share this post


Link to post
Share on other sites



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)"


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Glad to be of service :D


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Can you post the code you have so far?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

While 1 ;loop indefinitely

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

Sleep(30000) ;sleep 30 seconds

WinActivate("MaxTalk")

Sleep(30000) ;sleep 30 seconds

WEnd

Share this post


Link to post
Share on other sites

#8 ·  Posted (edited)

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

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

I was thinking about something like:

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

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

How do you start the PowerPoint presentation now?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
Share on other sites

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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Replace

WinActivate("PowerPoint Slide Show - [McLarenshopfloorPresentation]")
with
ShellExecuteWait("yourpresentation.pps")
and remove the Sleep statements that follow,


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0