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/d...ynamicDataExchangeChangesInVisualBasicNET.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]

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

 

[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.aspx?scid=kb;en-us;285339

HTH,

Sam

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

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.aspx?scid=kb;en-us;285339

HTH,

Sam

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

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.