[R] VBA

Албутова О.И. oalbutova at ippe.ru
Mon May 26 15:17:40 CEST 2014


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>


More information about the R-help mailing list