Ontime already works as you desire - if it takes the macro more than the
allotted time to finish, then you will have the problem you describe. Just
like two objects can't occupy the same space, two macros can't run at the
same time. You will have to change your interval to allow both macros to
run.

--
Regards,
Tom Ogilvy


"bondcrash" wrote:


Hi all,

I have this problem on which I am kind of stuck. I have an on-time
macro (say "A") that runs every five seconds and basically download a
data series, item by item. In that five seconds period in between runs,
another macros ("B") may need to run using the last item downloaded.
However what happens is that "B" doesnt run as the macro "A" is still
engaged until the next download and therefore stops "B" from running.

Ideally there must be a way the turn the "on time" into a series of
one-shot on-times (i.e. a series of single download macros basically ).


Any suggestion appreciated!!

Best
BC


--
bondcrash
------------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...o&userid=20997
View this thread: http://www.excelforum.com/showthread...hreadid=537175