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: Wed October 9, 2024 8:18 PM CFBB v1.2.0 29 ms.
© AderSoftware 2002-2003