[R] Excel

Erich Neuwirth erich.neuwirth at univie.ac.at
Fri Aug 31 10:41:03 CEST 2007

The quickest solution is to additionally install the package rcom from CRAN.
A more detailed account can be found on our wiki at
especially on

Greg Snow wrote:
> Erich,
> I just downloaded the latest version of the R dcom server etc from CRAN
> (version 2.5, I had looked at the previous version, but wanted to try
> the latest version (I will be responding to your e-mail, just wanted to
> test some things rather than speak from ignorance (not that I always
> take that approach))).
> When installing and further when running excel after the install I get
> an error and a visual basic debugger pops up.  The error window says:
> "Compile error: Can't find project or library", The code window is
> titled: "Rexcel.xla - MenuTools (Code)" and the line: "Function
> ExcelVersionMajor() As Integer" is highlighted in yellow, a couple of
> lines below that the word "Left" is highlighted/selected in the line
> "ExcelVersionMajor = Cint(Left(Application.Version, pos - 1))"
> I have Excel 2000.

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

More information about the R-help mailing list