Please post RExcel related questions on the rcom mailing list at [EMAIL PROTECTED]
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? -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ______________________________________________ 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.