Re: [R] RE xcel Macro Mode
Have you looked at RExcel and the RExcelInstaller package? There is now a companion book: Heiberger and Neuwirth (2009) R Through Excel: A Spreadsheet Interface for Statistics, Data Analysis, and Graphics (Springer)? Both Amazon and the Springer web site say it's not yet available. However, the Springer booth at the Joint Statistical Meetings was selling copies Monday and maybe Tuesday until they ran out. I believe that both Amazon and Springer would take your order and ship fairly soon. If this does not solve your problem I suggest you write directly to Heiberger or Neuwirth. Hope this helps. Spencer Graves ryusuke wrote: 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? __ 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.
Re: [R] RE xcel Macro Mode
spencerg wrote: Have you looked at RExcel and the RExcelInstaller package? There is now a companion book: Heiberger and Neuwirth (2009) R Through Excel: A Spreadsheet Interface for Statistics, Data Analysis, and Graphics (Springer)? Both Amazon and the Springer web site say it's not yet available. However, the Springer booth at the Joint Statistical Meetings was selling copies Monday and maybe Tuesday until they ran out. I believe that both Amazon and Springer would take your order and ship fairly soon. If this does not solve your problem I suggest you write directly to Heiberger or Neuwirth. Or (maybe better) post a question to the rcom mailing list http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l/ HTH, Tobias ryusuke wrote: 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? __ 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. __ 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.
Re: [R] RE xcel Macro Mode
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.