Have you looked at RExcel and the RExcelInstaller package?
There is now a companion book: Heiberger and Neuwirth (2009) R
Through Excel: A Spreadsheet Interface for Statistics, Data Analysis,
and Graphics (Springer)? Both Amazon and the Springer web site say it's
not yet available. However, the Springer booth at the Joint Statistical
Meetings was selling copies Monday and maybe Tuesday until they ran
out. I believe that both Amazon and Springer would take your order and
ship fairly soon.
If this does not solve your problem I suggest you write directly
to Heiberger or Neuwirth.
Hope this helps.
Spencer Graves
ryusuke wrote:
I would like to do so as well, but I faced some problems as well......
livia wrote:
Hi everyone, I would like to write VBA macros for accessing R and it is my
first attempt. I really could use some help here.
I am trying to use the following code to read data from Access. The R code
between "" is correct as I successfully run it from R, but when I call it
using VBA, it comes out the error message "Compile error Syntax error"
Call RInterface.RRun("mdbConnect <-
odbcConnectAccess("//c/users/Shared/data.mdb")")
If I would like to run a function , is the following codes correct?
Call RInterface.RRun("quareturn <- function(x){
...
...{
...
}
...
}")
Could anyone give me some advice?
______________________________________________
R-help@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.