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]
