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]
