[R] RE xcel Macro Mode

Tobias Verbeke tobias.verbeke at telenet.be
Wed Aug 5 13:36:31 CEST 2009


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




More information about the R-help mailing list