[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