Thread: macro clash
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bondcrash[_20_] bondcrash[_20_] is offline
external usenet poster
 
Posts: 1
Default macro clash


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