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