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
______________________________________________
[email protected] 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.