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
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
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.
Re: [R] RE xcel Macro Mode
Please post RExcel related questions on the rcom mailing list at
[EMAIL PROTECTED]
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
__
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.
