DDE real time and time dispay conflict

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.
 
T

Tom Ogilvy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximum Number of Bloomberg DDE Links 0
Copy value from changing cells without VBA 1
Excel 2002 recalculation while executing VBA Procedure 1
Maximum number of DDE links? 1
VBA with real time data 1
Real-time character counter 14
DDE link to outside application 1
Consuming DDE and providing XML 3

Top