ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   RefreshData Method in RTD Server (https://www.excelbanter.com/excel-programming/294874-refreshdata-method-rtd-server.html)

kitty

RefreshData Method in RTD Server
 
Hi,

I'm trying to build my own RTD Server for Excel using C++.
I downloaded the example available on msdn.com, and I'm trying to
modify the code to output something other than the current system
time.

I successfully modified the ConnectDate() method. However, I'm not
quite sure how the RefreshData() method works. How does the
RefreshData() method know what data I want to update? The list of
strings or topics from the RTD() function in Excel is passed into the
Strings parameter in ConnectData(), but how does RefreshData know what
the parameters are in order to create the output value to pass back to
Excel?

I think i probably lack an understanding of the RefreshData()
function.
Any help on this topic would be greatly appreciated!

Thanks,
Kitty
=)

Bill Renaud[_2_]

RefreshData Method in RTD Server
 
Which article did you see on MSDN? I found several that refer to this
subject - maybe one of these might provide some additional clues:

Building a Real-Time Data Server in Excel 2002 (Microsoft Excel 2002
Technical Articles)
http://msdn.microsoft.com/library/en...xlrtdbuild.asp

285339 - HOWTO: Create a RealTimeData Server for Excel
http://support.microsoft.com/default...b;en-us;285339

327215 - Create a RealTimeData Server for Excel 2002 or Later with Visual
C++
http://support.microsoft.com/default...b;en-us;327215

284878 - PRB: RTD Servers Used with Embedded Excel Workbooks May Be
Problematic
http://support.microsoft.com/default...b;en-us;284878

(Sorry, I have no experience with this topic, but can only throw out a few
quick suggestions. I'm using Excel 2000 SP-3.)
--
Regards,
Bill


"kitty" wrote in message
om...
Hi,

I'm trying to build my own RTD Server for Excel using C++.
I downloaded the example available on msdn.com, and I'm trying to
modify the code to output something other than the current system
time.

I successfully modified the ConnectDate() method. However, I'm not
quite sure how the RefreshData() method works. How does the
RefreshData() method know what data I want to update? The list of
strings or topics from the RTD() function in Excel is passed into the
Strings parameter in ConnectData(), but how does RefreshData know what
the parameters are in order to create the output value to pass back to
Excel?

I think i probably lack an understanding of the RefreshData()
function.
Any help on this topic would be greatly appreciated!

Thanks,
Kitty
=)





All times are GMT +1. The time now is 05:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com