Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE Links
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! -- JSP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow opening links between workbooks with links created in 2003 | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Relative Links becoming Absolute Links? | Excel Programming | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions |