Join the 80,000 other DTN customers who enjoy the fastest, most reliable data available. There is no better value than DTN!

(Move your cursor to this area to pause scrolling)




"Version 4.0.0.2 has been working well for me and I appreciate that it is now a much tighter client to work with. I feel I can go to press with my own application and rely on a stable platform" - Comment from David in IA.
"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"If someone needs the best quality data and backfill beyond what their broker provides at a rate that is the best in the industry, I highly recommend IQFeed." - Comment from Josh via Public Forum
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"Thanks for following up with me. You guys do a great job in tech support." - Comment from Phelps
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"DTN has never given me problems. It is incredibly stable. In fact I've occasionally lost the data feed from Interactive Brokers, but still been able to trade because I'm getting good data from DTN." - Comment from Leighton
"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
"It’s so nice to be working with real professionals!" - Comment from Len
"Interactive Brokers tick data was inconsistent, so I have switched to using DTN exclusively. It is great to no longer have to worry about my datafeed all day long." - Comment from Philippe
Home  Search  Register  Login  Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTNMarkets on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »Product Support »Data and Content Support »error using DTN sample DDE spreadsheed for Excel
Author Topic: error using DTN sample DDE spreadsheed for Excel (1 messages, Page 1 of 1)

jbclem
-Interested User-
Posts: 24
Joined: Feb 23, 2005


Posted: Aug 11, 2007 07:55 PM          Msg. 1 of 1
This is the .xls file that came with v. 4.2.1.4, the most recent version. I'm trying to make it work but when I run the macro to update the cells, a debug Microsoft Visual Basic screen comes up showing that there is an error in this line of the IQLink macro code:

If ((Cells(TempRow, FirstColumn - 1) <> "") And (Cells(FirstRow - 1, TempColumn) <> "")) Then

This line is highlighted in yellow.

This is the first time I've looked at this sample spreadsheet and tried to run the macro. Is anyone familiar enough with this macro code to spot what's wrong with it. I'm using Excel 2002 and Win2000.

John
 

 

Time: Fri March 24, 2023 8:06 PM CFBB v1.2.0 15 ms.
© AderSoftware 2002-2003