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.
______________________________________________
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.
