[R] RE xcel Macro Mode

[spencerg]

      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?
>>
>>     
>
>