[R] RE xcel Macro Mode
spencerg
spencer.graves at prodsyse.com
Wed Aug 5 13:23:23 CEST 2009
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?
>>
>>
>
>
More information about the R-help
mailing list