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? -- View this message in context: http://www.nabble.com/RExcel-Macro-Mode-tf4778781.html#a13670651 Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.