[R] RE xcel Macro Mode

Erich Neuwirth erich.neuwirth at univie.ac.at
Sat Nov 10 08:28:06 CET 2007


Please post RExcel related questions on the rcom mailing list at
rcom-l at mailman.csd.univie.ac.at


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



More information about the R-help mailing list