[R] R and DDE (Dynamic Data Exchange)
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
> sh <- COMCreate("Shell.Application")
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!
> 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)
>>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
> 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