R help - Dec 2002 - Linking R script and a COM application

I am new to R. I run it under MS Windows.

My goal is to interface an existing R program (500 lines) with a commercial
software. That one
can be used as an OLE-Server. Ideally I would be able to reference and control
the R-program
and components of the other software out of one VBA program. To make it easier,
the R script
has no text or graphics output. I have downloaded
http://cran.r-project.org/contrib/extra/dcom/
but I do not understand:

?? what command do I use in VBA to run an existing COM script ??

Can someone send me a sample of VB code?

Wolfgang Scherr
Innovative Transportation Concepts, Inc.
302-654-4384 phone
wscherr at itc-world.com

Wolfgang Scherr wrote:
> 
> I am new to R. I run it under MS Windows.
> 
> My goal is to interface an existing R program (500 lines) with a commercial
software. That one
> can be used as an OLE-Server. Ideally I would be able to reference and
control the R-program
> and components of the other software out of one VBA program. To make it
easier, the R script
> has no text or graphics output. I have downloaded
http://cran.r-project.org/contrib/extra/dcom/
> but I do not understand:
> 
> ?? what command do I use in VBA to run an existing COM script ??
> 
> Can someone send me a sample of VB code?
Take a look into the R-Excel Interface (by Erich Neuwirth,
http://cran.r-project.org/contrib/extra/excel) which has several
examples, becauses it uses DCOM heavily.

Uwe Ligges

Andrew,

thank you for your response. However, the Oregon Department of Transportation
has taken the
decision to go with R for some particular applications. Seems, that they like
the open code
idea. And I am only an employee of a small consultant, so I can hardly change
their path.

Wolfgang

> -----Original Message-----
> From: ANDREW WARD [mailto:s195404 at student.uq.edu.au]
> Sent: Tuesday, December 24, 2002 3:28 AM
> To: wscherr at itc-world.com
> Subject: Re: [R] Linking R script and a COM application
>
>
> Wolfgang,
>
> While some of this may be possible in R, S-PLUS is much better at doing
this
> sort of thing. I suspect that Windows connectivity is a low priority for
the
> (volunteer) developers of R. The commercial publishers of S-PLUS, on the
other
> hand, have the resources to do this. R code can usually be transferred
fairly
> easily to S-PLUS, and the features you want are available and documented
> there. Is using S-PLUS an option?
>
> Regards,
>
> Andrew C. Ward
>
> CAPE Centre
> Department of Chemical Engineering
> The University of Queensland
> Brisbane Qld 4072 Australia
> andreww at cheque.uq.edu.au
>
>
> Quoting Wolfgang Scherr <wscherr at itc-world.com>:
>
> > I am new to R. I run it under MS Windows.
> >
> > My goal is to interface an existing R program (500 lines) with a
commercial
> > software. That one
> > can be used as an OLE-Server. Ideally I would be able to reference and
> > control the R-program
> > and components of the other software out of one VBA program. To make
it
> > easier, the R script
> > has no text or graphics output. I have downloaded
> > http://cran.r-project.org/contrib/extra/dcom/
> > but I do not understand:
> >
> > ?? what command do I use in VBA to run an existing COM script ??
> >
> > Can someone send me a sample of VB code?
> >
> > Wolfgang Scherr
> > Innovative Transportation Concepts, Inc.
> > 302-654-4384 phone
> > wscherr at itc-world.com
> >
> > ______________________________________________
> > R-help at stat.math.ethz.ch mailing list
> > http://www.stat.math.ethz.ch/mailman/listinfo/r-help
> >
>