Execute application macro question

[niki]

Hello,
I am controling a windows based application with a macro. This application sends multiples spyders to retrieve data from the web. I have about ten different spyders. My problem is that when I create the macro which is gonna run them automatically, they all run together which causes a total use of my PC's CPU capacity, and therefore a crash of the programs.

It does this whether I put all the Execute application actions in a single macro, or if I bind all the macros to a general macro (each macro having a single Execute application action).

How can I program this macro so that it waits for the first macro to be finished and starts the followaing and so on?

Maybe by setting a timer which leaves let's say ten minutes to each spyder to retrieve the data?

Or setting up the macro to work step by step...

But I dunno how to do help me!

Thanks
cheers

nico

 

[FoFa]

Have you considered creating a .BAT file with the START /W commands running your Spiders and just starting that from you program? The /W parm on the Command Line Start command says wait until it finishes before running the next command.

 

[niki]

No actually I never did, because I dunno how to do that!
Can Access use a bat file instead of a macro?
How can I create a bat file?

Thx for your help!

nico

 

[niki]

If anyone ever reads this post again and has the same trouble as I did. Just create a text file using notepad or whatever...
Type in this code:

@echo off
start /w cmd /c "C:\Program Files\myprog.exe"
start /w cmd /c "C:\Program Files\myprog2.exe"
'...
start /w cmd /c "C:\Program Files\myprog99.exe"
cls

Save it as "whatever.bat"

And run it with a macro using the run application command on the bat file.

It works fine

cheers
nico