[R] VBA

Jeff Newmiller jdnewmil at dcn.davis.CA.us
Mon May 26 18:51:55 CEST 2014


Wrong forum. Please contact Statconn for support.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

On May 26, 2014 6:17:40 AM PDT, "Албутова О.И." <oalbutova at ippe.ru> wrote:
>Good day!
>
>I'm trying to make VBA program with R functions in Excel. I've
>installed
>RExcel and it works. But when I put such a code in VBA,
>
>Sub Demo()
>
>Call RInterface.StartRServer
>
>Call RInterface.RRun("z <- rnorm(60)")
>
>Call RInterface.RRun("dim(z) <- c(10,6)")
>
>Call RInterface.GetArray("z", Range("Sheet1!A19"))
>
>Call RInterface.StopRServer
>
>End Sub
>
>
>
>it doesn't work. The error is '424' - Object required.
>
>I took this code from the article <High-Level Interface Between R and
>Excel>
>Thomas Baier Erich Neuwirth, page 6
>
>My version of Excel is 2010, Windows 7.
>
>
>
>Thank you!
>
>
>
>Sincerely yours,
>
>Olga
>
>
>
>---
>Это сообщение свободно от вирусов и вредоносного ПО благодаря защите от
>вирусов avast!
>
>
>
>------------------------------------------------------------------------
>
>______________________________________________
>R-help at r-project.org 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.



More information about the R-help mailing list