Thanks a lot, This seemingly solved the problem Gabor -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: 2008. október 30. 09:28 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Problem installing RSrv250.exe
If you also install rcom and then run library(rcom) comRegisterRegistry() that should solve your problem. The reason is that RSrv250 installs an outdated version of RExcel which has this problem. The package RExcelInstaller on CRAN installs the latest version of RExcel which does not have this problem either. Hanák Gábor wrote: > Sorry, Greg, > > It is reporting the same problem. > What I did was: > 1. I completely removed R 2.8.0 > 2. I completely removed R/Scilab (D)Com Server 2.50 and RExcel 1.75 3. > I installed R 2.7.2 (it was fine) 4. I installed R/Scilab (D)Com > Server 2.50 and RExcel 1.75 Unfortunately upon completion of task 4, I > experienced exactly the same error (stopping execution of the VBA > program with the LEFT function being the problem). > Shall I go back to even older version of R? Which one? > > Gabor > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Greg > James > Sent: 2008. október 29. 15:59 > To: 'R (D)COM and RExcel server related issues' > Subject: RE: [Rcom-l] Problem installing RSrv250.exe > > Gabor, > > RDCom is not currently compatible with R-2.8.0. I had the same problem > and found that R-2.8.0 no longer installs an rproxy.dll file which is > what RDCom is programmed to look for. There is no workaround right now > except dropping back to R-2.7.2 which is what I've done. > > The VBA error message is due to Application.Version sending an illegal > value to the left function. > > -Greg > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Hanák > Gábor > Sent: Wednesday, October 29, 2008 7:08 AM > To: rcom-l@mailman.csd.univie.ac.at > Subject: [Rcom-l] Problem installing RSrv250.exe > > Can anybody help me with the following installation probelm? > > I use Windows XP Professional Version 5.1 (SP3) I use Microsoft Office > Excel > 2003 SP3 I successfully installed R 2.8.0 When I wanted to install > RSrv250 it went smothly for a while and after I got a message saying > "Completing the R/Scilab (D)Com Server and RExcel Setup Wizard", I pushed the "Finish" > button. > Then the program started Microsoft Visual Basic and in the file > RExcel.xla, in the project RExcelVBAlib, in the module MenuTools, in > the function > ExcelVersionMajor() a compile error was reported saying: "Can't find > project or library" and the in the statement > " ExcelVersionMajor = CInt(Left(Application.Version, pos - 1))" > the function "Left" was highlighted. > I do not understand why the Left function was not found, if I go to > the Object Browser then I can find Left as "Function Left(String, > Length As Long)". > > As a result, after stopping the execution of the Visual Basic program > and starting Excel, the same error message is generated. Then I can > only use Excel properly if I uncheck RExcel in the Add-ins dialog. If > I check RExcel, the same thing happens. Thus it seems I can not use RExcel at all. > > Thanks for any help > Gabor > > _______________________________________________ > Rcom-l mailing list > Rcom-l@mailman.csd.univie.ac.at > http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l > More information (including a Wiki) at http://rcom.univie.ac.at > > _______________________________________________ > Rcom-l mailing list > Rcom-l@mailman.csd.univie.ac.at > http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l > More information (including a Wiki) at http://rcom.univie.ac.at > > _______________________________________________ > Rcom-l mailing list > Rcom-l@mailman.csd.univie.ac.at > http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l > More information (including a Wiki) at http://rcom.univie.ac.at > > > ---------------------------------------------------------------------- > -- > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.175 / Virus Database: 270.8.4/1753 - Release Date: > 10/28/2008 9:20 PM > -- 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 _______________________________________________ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at _______________________________________________ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at
