peterhoa wrote:
I forgot to mention that it's Excel 2007 beta 2.

"peterhoa" wrote in message
...
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.

Sorry, no answer to your question but I can say that I see exactly the
same behaviour he writing =RTD() directly in the worksheet cells
works fine but using a wrapper function returning
Excel.Application.WorksheetFunction.RTD() doesn't work. I can see that
in the latter case Excel calls my ConnectData() just as usual but
almost immediately thereafter it calls DisconnectData() -- without any
apparent reason. Even more surprizingly, it still calls RefreshData()
for the topic it just disconnected from.

The fact that =RTD() in the worksheet works makes me suspect that this
is a beta2 bug, I hope this wasn't a conscious design decision in Excel
2007, so I can only hope it's going to be fixed in the final version.

Regards,
VZ