The are described in out Wiki at
http://rcom.univie.ac.at
Currently, R(D)COM version 2.51 has a problem with RExcel when rcom is
not installed. There are 2 solutions.
* Install rcom from CRAN, and then in R execute the following commands
1. library(rcom)
2. comRegisterRegistry()
3. comRegisterServer()
* Download and install the updated version from
http://rcom.univie.ac.at/download/current/RSrv250_pl1.exe
and install it
Leonard Mada wrote:
> I had exactly the same problem, before activating VB. This is about a
> rather obscure VB activation issue.
>
> You can let the security to *medium*, NO need to set it to low.
>
> BUT, in the Tool->Macro Dialog->Security, in the *Trusted Sources* tab
> you need to check the *trust VB project* checkbox. That was pretty
> tricky, I played some 2-3 weeks, before I detected that option.
>
> Hope this helps.
>
> Leonard
>
>
>
> Kohei Yoshida wrote:
>> Leonard Mada wrote:
>>> Kohei Yoshida wrote:
>>>> Kohei Yoshida wrote:
>>>>> Better yet, I can probably spend some time with it after I'm back from
>>>>> Prague.
>>>>>
>>>>> Is this
>>>>> http://cran.r-project.org/contrib/extra/dcom/
>>>>> where we find the latest version of RExcel?
>>>>>
>>>> I installed Excel 2003, R, and RExcel, but it failed on startup when
>>>> it fails to access "Application.Version". Does anyone have any idea
>>>> about this?
>>>>
>>>> Kohei
>>>>
>>> Have you activated VB macros? I had some problems, too, until I
>>> recognized that VB was deactivated.
>>
>> Thanks. My macro security setting was set to medium, so I reset it to
>> low (the lowest setting I could set). I'm still getting an error on
>> startup.
>>
>> What puzzles me is that, it has trouble executing the built-in
>> Left(...) function inside the following macro code:
>>
>> Function ExcelVersionMajor() As Integer
>> Dim pos As Integer
>> pos = InStr(Application.Version, ".")
>> If pos > 0 Then
>> ExcelVersionMajor = CInt(Left(Application.Version, pos - 1))
>> Else
>> ExcelVersionMajor = 0
>> End If
>> End Function
>>
>> I haven't touched VBA for many years now, but I thought Left(...) was
>> a pretty standard function.
>>
>> Indeed, moving the cursor over Left and hitting F1 doesn't bring up
>> help on that function. So, looks like that function is no longer in
>> the standard library...
>>
>> Anyway,
>>
>> Kohei
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
--
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
