DDE Links

J

JSP

I am having trouble with my DDE Links. After several iterations in a Excel
VBA (MACRO) program, the DDE does not update. It seems to be worst in XP Pro
with 2007 Office. The code works reasonabely well with Vista (unbelievabele
I know). It is recieving data from InterbankFX. This is the code I'm using:

Sub ReadData(Bid(), Offer(), c, Res())

channel = DDEInitiate("MT", "BID")
Result = DDERequest(channel, "EURUSD")
Cells(15, 1) = Result

channel = DDEInitiate("MT", "ASK")
Result = DDERequest(channel, "EURUSD")
Cells(15, 2) = Result

Do

channel = DDEInitiate("MT", "BID")
Result = DDERequest(channel, "EURUSD")
Cells(16, 1) = Result

channel = DDEInitiate("MT", "ASK")
Result = DDERequest(channel, "EURUSD")
Cells(16, 2) = Result

Bid(c) = Cells(16, 1)
Offer(c) = Cells(16, 2)

Loop Until Cells(16, 2) <> Cells(15, 2)

Thank!
 

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

Top