LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default RTD wrapper functions do not work in Excel 2007

I sell an addin which links to a number of real time providers (eSignal,
market feed...) using a dll (written to the RTD standard). I use VBA
wrapper functions which in turn call the RTD dll. Works fine with Excel 2002
and Excel 2003. It does NOT work with Excel 2007 however. I've recompiled
the dll to ensure the VB 6.0 reference includes the 2007 libraries. If I use
the RTD function directly from a worksheet cell it DOES work. This shows the
dll is functioning correctly. However, when it's included in a VBA wrapper
function nothing happens. ie cell values are not updated. I've stipped the
dll down to the point where it simply displays the time -- ie a few lines of
code -- with the same result: wrapper functions do not work.

Wrapper functions are essential as asking users to use RTD direct is complex
and not a practical solution for average users. Has anybody else had a
problem with wrapper fucntions?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get any of my functions to run in Excel 2007 0to60 Excel Worksheet Functions 2 October 25th 08 04:21 AM
Excel 2007 -Where did the ALT-E functions go? Tom at JDH Setting up and Configuration of Excel 1 January 17th 08 07:24 PM
Excel 2000, RAND and IF functions do not work together for me Jesse CH Excel Worksheet Functions 8 July 5th 07 01:58 PM
2007 Excel Functions pglufkin Excel Worksheet Functions 1 December 20th 06 02:33 AM
Call VB6 DLL from Worksheet without VBA wrapper Lawrence[_3_] Excel Programming 2 September 19th 03 10:04 AM


All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"