Re: [R] R and DDE (Dynamic Data Exchange)

From: Philippe Grosjean <>
Date: Wed 19 Jul 2006 - 18:06:35 EST

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! Best,

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, <> 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.
>> mailing list
>>PLEASE do read the posting guide!
> ______________________________________________
> mailing list
> PLEASE do read the posting guide!
> and provide commented, minimal, self-contained, reproducible code.
> mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Wed Jul 19 18:17:57 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Wed 19 Jul 2006 - 20:18:00 EST.

Mailing list information is available at Please read the posting guide before posting to the list.