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)




"I just wanted to say how happy I am with your service. I was able to download the API docs last week and I was able to replicate Interactive Brokers historical bar queries and realtime bar queries over the weekend. That was about one of the fastest integrations that I've ever done and it works perfectly!!!!" - Comment from Jason via Email
"Everything is working amazing now. I'm already impressed with the true-tick feed of IQFeed and it's ability to support my 480 symbol layout." - Comment from Tyler via Email
"I have been using IQFeed now for a few years in MultiCharts and I have zero complaints. Very, very rare to have any data hiccups or anything at all go wrong." - Comment from Public Forum
"I just wanted to let you know how fast and easy I found it to integrate IQFeed into our existing Java code using your JNI client. In my experience, such things almost never go so smoothly - great job!" - Comment from Nate
"I am keeping IQFeed, much better reliabilty than *******. I may refer a few other people in the office to switch as well." - Comment from Don
"I've been using Neoticker RT with IQFeed for two months, and I'm very happy with both of the products (I've had IQFeed for two years with very few complaints). The service from both companies is exceptional." - Comment from Public Forum
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"I just wanted to tell you what a fine job you have been doing. While *******, from what I hear, has been down and out, off and on, IQ feed has held like a champ this week." - Comment from Shirin
"I am very happy I changed. I love the product, but more so I am thrilled with Tech Support. You are knowledgeable, polite, pleasant and professional." - Comment from Pat
"I am very pleased with the DTNIQ system for quotes and news." - Comment from Larry
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 »Archive (2017 and earlier) »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: Tue May 7, 2024 5:57 PM CFBB v1.2.0 12 ms.
© AderSoftware 2002-2003