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

This article may assist:

Building a Real-Time Data Server in Excel 2002
http://msdn.microsoft.com/library/de...xlrtdbuild.asp


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Hans Guijt" wrote in message
. nl...
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

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" wrote in message
...
This article may assist:

Building a Real-Time Data Server in Excel 2002

http://msdn.microsoft.com/library/de...xlrtdbuild.asp


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Hans Guijt" wrote in message
. nl...
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

Maybe this MS KB article will assist

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


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Hans Guijt" wrote in message
. nl...
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" wrote in message
...
This article may assist:

Building a Real-Time Data Server in Excel 2002

http://msdn.microsoft.com/library/de...xlrtdbuild.asp


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Hans Guijt" wrote in message
. nl...
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

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).

--
Regards
Thomas

http://rtsoftwaredevelopment.de


"Hans Guijt" schrieb im Newsbeitrag
. nl...
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" wrote in message
...
This article may assist:

Building a Real-Time Data Server in Excel 2002


http://msdn.microsoft.com/library/de...us/dnexcl2k2/h
tml/odc_xlrtdbuild.asp


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Hans Guijt" wrote in message
. nl...
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