[R] link R to VB

Prof Brian D Ripley ripley at stats.ox.ac.uk
Sat Feb 10 10:06:10 CET 2001

On Fri, 9 Feb 2001, Yu-Ling Wu wrote:

> Hi,
> 1. How to dynamic link the outputs from R to MS-Word
> or MS-Excel?

I am not sure what you mean here.  If you mean something like OLE, you
can't fo that with R (and why would you want to?).  What `output' did you
have in mind, anyway?  For matrices of data you can use RODBC from R to
link to Excel, and he R-Excel interface to link from Excel (which is based
on my answer to 2.).

> 2. I'd like to develop an VB application and use R as
> the "backgroud calculator".
> How do I call R and its function in VB?

Use the DCOM interface by Thomas Baier, on CRAN under

Software->Other->Non-standard Packages.

I should warn that none of this is plug-and-play and needs care to
follow the instructions exactly.  But the DCOM interface has been used by
many people, and very effectively.

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch

More information about the R-help mailing list