[R] R and DDE (Dynamic Data Exchange)

Philippe Grosjean phgrosjean at sciviews.org
Wed Jul 19 10:06:35 CEST 2006

Gabor Grothendieck wrote:
> You can access DDE via COM as in this example
> which uses DDE to open an Excel file.  Note that
> Excel also supports COM directly and normally
> one would use COM with Excel, not DDE, so you
> might check if your application also supports COM.
> # opens an excel spreadsheet c:\test.xls using dde
> library(RDCOMClient)
> sh <- COMCreate("Shell.Application")
> sh$Namespace("C:\\")$ParseName("test.xls")$InvokeVerb("&Open")

Well, I think you are really using COM here, not DDE. M$ implemented the 
same DDE commands in Excel and Word in COM to ease upgrading from DDE to 
COM... but the internal is completelly different!

Philippe Grosjean

> Also if you are going to access DDE via COM or just COM also
> check out the rcom package which is similar to RDCOMClient.
> On 7/17/06, vincent at 7d4.com <vincent at 7d4.com> wrote:
>>R and DDE (Dynamic Data Exchange)
>>Dear Rusers,
>>I run an application (not mine) which acts as a DDE server.
>>I would like to use R to get data from this application,
>>say once per minute, and do some processing on it.
>>I didn't find much info on the R DDE abilities, apart the tcltk2
>>package in which I will try to go deeper.
>>I would be very thankful for any info, pointer or advice about the
>>"good ways" to make R program get online data from a DDE server.
>>R-help at stat.math.ethz.ch mailing list
>>PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

More information about the R-help mailing list