How to implement an iRtdServer?

[Hans Guijt]

Hi,


I wish to add an RTD server for Excel to an existing C++ application (using
Visual Studio 6). So far I have figured out that I need COM, and the
iRtdServer class. I think I have more or less figured out the COM thing, but
I still need the elusive iRtdServer class. I would appreciate it if someone
could help me with some pointers on where to find the class, or perhaps even
a (C++) code example showing how to implement the entire server.


Thanks in advance,

Hans Guijt

 

[Rob van Gelder]

This article may assist:

Building a Real-Time Data Server in Excel 2002
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xlrtdbuild.asp

 

[Hans Guijt]

Hi Rob,


Thanks for the response. I had already read that article, but it still
leaves me with a number of questions, the most important of which is "where
do I find the C++ definition for the iRtdServer class"?

As I understand it, I must inherit my own class from that class, and add the
functionality that I need to ConnectData(), DisconnectData()., etc. If new
data arrives in my application I can call RefreshData() to cause Excel to
update its window.

As I said, I haven't actually done anything with COM before, so I'm not
entirely sure how to proceed.


Regards,

Hans Guijt

 

[Rob van Gelder]

Maybe this MS KB article will assist

http://support.microsoft.com/?id=327215

 

[Thomas Risi]

Hi Hans,

"where do I find the C++ definition for the iRtdServer class"?

IRTDServer is an interface which you have to implement in your application.
It is part of the excel objectlibrary. You can use the oleview-tool from
Microsoft for finding it.

As I said, I haven't actually done anything with COM before ...

If you have no experience with COM it will be a hard job ;-)
There is example-project (using no ATL) in the knowledgebase. You will find
the download in kb327215.

There are several ways for creating the rtd-server. If it's possible for
you, choose the VisualBasic6- or dotnet-way (is much easier).