R help - May 2014 - VBA

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!

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Article.pdf
Type: application/pdf
Size: 267617 bytes
Desc: not available
URL:
<https://stat.ethz.ch/pipermail/r-help/attachments/20140526/9eb7ff09/attachment.pdf>

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.