DDE real time and time dispay conflict

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am pulling real time stock (10 stocks)data into sheet1 andlinking each
stockto its own sheet on which I have a number of analytics in XL function
which updae as the data streams in.

I would like to use VBA procedures to increase the power of the analytics
but when I run any of these procedures it blocks the standard recalculation.

I have the same problem running a simple real time timedisplay
into a cell in one sheet.

Does this mean that when a VBA procedure runs there is nothing else that can
be done?

What if I use two instances of Excel and use one for DDE and link to the
other one where the Excel formulas are.

I have plenty of RAM but is there an intrinsic limit of how many instances I
can have running?

Many thanks of any help.
 
Easiest would be to test it out. I don't think there is an intrinsic limit
since some people that screw up their automation code have many instances
running.
 
Back
Top