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

From: Philippe Grosjean <phgrosjean_at_sciviews.org>
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, vincent@7d4.com <vincent@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.
>>Thanks
>>Vincent
>>
>>______________________________________________
>>R-help@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
>>
>
>
> ______________________________________________
> R-help@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.
>
>



R-help@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. 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 https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.