Execute application macro question

[nicolascaprais]

Hello all,

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 in the second case).



How can I program this macro so that it waits for the first macro to be
finished and starts the following 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 it, help me!



Thanks

cheers



nico

 

[Van T. Dinh]

I guess the first step is find an appropriate newsgroup to
post to, NOT this newsgroup.

This newsgroup is for Microsoft Access, a database
application and I haven't seen Microsoft Access
sending "spyders to retrieve data from the Web".

HTH
Van T. Dinh
MVP (Access)