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 will tell others who want to go into trading that DTN ProphetX is an invaluable tool, I don't think anyone can trade without it..." - Comment from Luther
"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
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"I had always used ******* but for the past 2 weeks have been trying DTN IQFeed. Customer support has been extraordinary. They call just to make sure your problem hasn't recurred." - Comment from Public Forum
"I'm very glad I switched to IQFeed. It's working perfectly with no lag, even during fast market conditions." - Comment from Andy via Email
"Its working FABULOUSLY for me!! Holy cow...there has been so much I've been missing lately, and with this feed and Linnsoft software...I'm in the game now." - Comment from Chris R.
"You have an excellent product !!!!!!" - Comment from Arely
"If you are serious about your trading I would not rely on IB data for serious daytrading. Took me a while to justify the cost of IQ Feed and in the end, it's just a 2 point stop on ES. Better safe than sorry" - Comment from Public Forum
"You have an excellent feed. Very few spikes for Spot Forex." - Comment from Public Forum Post
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 28, 2024 8:39 PM CFBB v1.2.0 5 ms.
© AderSoftware 2002-2003