RTD replace DDE in .NET?

[Marty]

Hi,

I've been reading that in .NET, RTD replace the VB6 DDE. With VB6 DDE
it was possible to read from an Excel sheet to a textbox for instance,
if we had the topic and source.

I know that VB.NET to Excel (through RTD) is easy, but can we connect
the VB.NET app. directly to the RTD server to be able to read from it?

Thanks you,

Marty

[Mike McIntyre [MVP]]

Support for DDE ends after VB6.

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

Use this search term in Google:

.net RTD server

to see articles on using RTD server with .NET.
--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com

"Marty" <xm******@hotmail.com> wrote in message
news:MJHSd.16682$0h.11637@clgrps13...

Hi,

I've been reading that in .NET, RTD replace the VB6 DDE. With VB6 DDE it
was possible to read from an Excel sheet to a textbox for instance, if we
had the topic and source.

I know that VB.NET to Excel (through RTD) is easy, but can we connect the
VB.NET app. directly to the RTD server to be able to read from it?

Thanks you,

Marty

[Marty]

Hello Mike,

I already have a RTD server. And I also can make an Excel spreadsheet
connect and receive quote from it.

But I want to bypass the Excel sheet. I want my VB.NET appl connect to
the RTD server and receive the quotes. (maybe using a similar syntax as
in Excel: =RTD("Stock.Quote", , [Ticker], [Type (Open|Last)]) )

I can't find any information about how to do it. Do you think it is
possible?

Thanks you

Marty
Mike McIntyre [MVP] wrote:

Support for DDE ends after VB6.

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

Use this search term in Google:

.net RTD server

to see articles on using RTD server with .NET.

[Samuel R. Neff]

An RTD "server" is just a COM object that implements the IRTDServer
interface. Any application can instantiate the COM object and use the
interface methods to use the server the same way Excel does.

This KB article shows how to create a server, but it also demonstrates
the interface RTD servers expose.

http://support.microsoft.com/default...b;en-us;285339

HTH,

Sam
On Tue, 22 Feb 2005 16:30:52 GMT, Marty <xm******@hotmail.com> wrote:

Hello Mike,

I already have a RTD server. And I also can make an Excel spreadsheet
connect and receive quote from it.

But I want to bypass the Excel sheet. I want my VB.NET appl connect to
the RTD server and receive the quotes. (maybe using a similar syntax as
in Excel: =RTD("Stock.Quote", , [Ticker], [Type (Open|Last)]) )

I can't find any information about how to do it. Do you think it is
possible?

Thanks you

Marty

B-Line is now hiring one VB.NET developer for
WinForms + WebServices position with ASPX in future.
Seaking mid to senior level developer. For
information or to apply e-mail sam_blinex_com.

[Marty]

Hi Samuel,

ok, I don't have this IRtdServer object (in my VB.NET) that they use in
the example. But if I had it, if I understand, I could connnect to the
RTD server using the IRtdServer interface?

=RTD("ExcelRTD.RTDFunctions",,"AAA", 5)
In this case, how do I connect to the ExcelRTD.RTDFunctions from the
IRtdServer interface?

I'm not sure about this part, thanks you for your help :)

Marty
Samuel R. Neff wrote:

An RTD "server" is just a COM object that implements the IRTDServer
interface. Any application can instantiate the COM object and use the
interface methods to use the server the same way Excel does.

This KB article shows how to create a server, but it also demonstrates
the interface RTD servers expose.

http://support.microsoft.com/default...b;en-us;285339

HTH,

Sam
On Tue, 22 Feb 2005 16:30:52 GMT, Marty <xm******@hotmail.com> wrote:

Hello Mike,

I already have a RTD server. And I also can make an Excel spreadsheet
connect and receive quote from it.

But I want to bypass the Excel sheet. I want my VB.NET appl connect to
the RTD server and receive the quotes. (maybe using a similar syntax as
in Excel: =RTD("Stock.Quote", , [Ticker], [Type (Open|Last)]) )

I can't find any information about how to do it. Do you think it is
possible?

Thanks you

Marty

B-Line is now hiring one VB.NET developer for
WinForms + WebServices position with ASPX in future.
Seaking mid to senior level developer. For
information or to apply e-mail sam_blinex_com.

[Samuel R. Neff]

Forget about the interface, it's just confusing the issue (sorry I
brought it up--you can program generically to the interface but for
starters you can program to a specific object).

Just use ExcelRTD.RTDFunctions directly like you would any other COM
object.

Best regards,

Sam
On Tue, 22 Feb 2005 19:12:35 GMT, Marty <xm******@hotmail.com> wrote:

Hi Samuel,

ok, I don't have this IRtdServer object (in my VB.NET) that they use in
the example. But if I had it, if I understand, I could connnect to the
RTD server using the IRtdServer interface?

=RTD("ExcelRTD.RTDFunctions",,"AAA", 5)
In this case, how do I connect to the ExcelRTD.RTDFunctions from the
IRtdServer interface?

I'm not sure about this part, thanks you for your help :)

Marty

B-Line is now hiring one VB.NET developer for
WinForms + WebServices position with ASPX in future.
Seaking mid to senior level developer. For
information or to apply e-mail sam_blinex_com.