Re: [Rcom-l] R (D)COM Server
Hi First of all: Thank you very much! Now Rexcel is running, I get the RExcel menu in Excel but unfortunately i cant write macros for R. I get the errormassege: "runtime error 424: Object needed" just in case I copied the clipboard as recommended by Erich RExcel Version: 3.0.6 (20081202-2) RExcel add-in file: C:\Programme\RExcel\xls\RExcel.xla RExcel Registry entry: "C:\Programme\RExcel\xls\RExcel.xla" RCOM server version: 2.0 R version: 2.8.0 R Home from Registry:C:\Programme\R\R-2.8.0 R_HOME from environment: not defined Excel version11.0 Excel home C:\Programme\Microsoft Office\OFFICE11 Excel file version: 11.0.5612.0 Excel product version: 11.0.5612.0 Excel language: German (Standard) Excel UI language: German (Standard) Excel Help language: German (Standard) Windows version Windows (32-bit) NT 5.01 Windows home:C:\WINDOWS WinVer version: 5.1.2600.5512 WinVer product version: 5.1.2600.5512 Windows language:German (Standard) Windows UI language: German (Standard) Programs Home: C:\Programme Original-Nachricht > Datum: Tue, 02 Dec 2008 15:05:51 +0100 > Von: Erich Neuwirth <[EMAIL PROTECTED]> > An: "R (D)COM and RExcel server related issues" > > Betreff: Re: [Rcom-l] R (D)COM Server > Do you have a full installation of Excel or only a standard installation? > > When you start Excel now, do you get the RExcel menu? > > If yes, got into RExcel -> About > and click copy to clipboard and then paste the clipboard content in an > email you send to the list. > > > > > > Christoph Hamer wrote: > > Hi > > > > I did as recommended: > > > > - download R 2.8.0 > > - download and execute > http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe > > - install Rexcel from R > > > > If i try to open rexcel it dies and I get strange error messages (sorry > its german): > > > > "Kompilierungsfehler in verborgenem Modul ThisWorkbook" > > > > Afterwards the Programm tells me: > > > > "RExcel is now configured for Excel 2003" > > > > "Fehler beim Kompilieren die Objektbibliothek ist ungültig oder > enthällt Verweise Objektdefinitionen, die nicht gefunen werden konnten." > > > > I am a puzzeled since i just followed the instructions below. > > > > What or where did I mess up? > > > > Cheers Christoph > > > > > > Original-Nachricht > >> Datum: Mon, 01 Dec 2008 21:14:29 +0100 > >> Von: Thomas Baier <[EMAIL PROTECTED]> > >> An: "R (D)COM and RExcel server related issues" > > >> Betreff: Re: [Rcom-l] R (D)COM Server > > > >> Christoph Hamer schrieb: > >>> Hi, > >>> > >>> i am interested in using R, Rexcel and an extra insurance package > >> (either reserving or Chainladder). > >>> Unfortunately I was not able to find the exe of the compulsory R > (D)COM > >> Server. > >>> The only thing i can find is a not working link to > >>> > >>> > >> > http://rcom.univie.ac.at/download/RAndFriends.distro/RAndFriendsSetup2072V3.0-3.exe > > >>> on > >>> > >>> > >> > http://learnserver.csd.univie.ac.at/rcomwiki/doku.php?id=rexcel_as_an_r_package > >>> R is so cool and would be so much more powerfull if i coult use it > with > >> Excel together. > >> > >> Try http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe > >> > >> and install the package RExcelInstaller from within R. > >> > >> Thomas > >> > >> ___ > >> 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.176 / Virus Database: 270.9.12/1823 - Release Date: > 12/1/2008 7:59 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 -- Sensationsangebot verlängert: GMX FreeDSL - Telefonanschluss + DSL für nur 16,37 Euro/mtl.!* http://dsl.gmx.de/?ac=OM.AD.PD003K1308T4569a ___ 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
Re: [Rcom-l] R (D)COM Server
During installation you have the options of standard or complete install. Christoph Hamer wrote: > Thank you for your fast reply > > My Excel edition came with "MS Office Professional Edition 2003" so i guess > its a full installation. > > If i start Excel there is no RExcel button but i get the error messages > described below. > > > > Original-Nachricht >> Datum: Tue, 02 Dec 2008 15:05:51 +0100 >> Von: Erich Neuwirth <[EMAIL PROTECTED]> >> An: "R (D)COM and RExcel server related issues" >> >> Betreff: Re: [Rcom-l] R (D)COM Server > >> Do you have a full installation of Excel or only a standard installation? >> >> When you start Excel now, do you get the RExcel menu? >> >> If yes, got into RExcel -> About >> and click copy to clipboard and then paste the clipboard content in an >> email you send to the list. >> >> >> >> >> >> Christoph Hamer wrote: >>> Hi >>> >>> I did as recommended: >>> >>> - download R 2.8.0 >>> - download and execute >> http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe >>> - install Rexcel from R >>> >>> If i try to open rexcel it dies and I get strange error messages (sorry >> its german): >>> "Kompilierungsfehler in verborgenem Modul ThisWorkbook" >>> >>> Afterwards the Programm tells me: >>> >>> "RExcel is now configured for Excel 2003" >>> >>> "Fehler beim Kompilieren die Objektbibliothek ist ungültig oder >> enthällt Verweise Objektdefinitionen, die nicht gefunen werden konnten." >>> I am a puzzeled since i just followed the instructions below. >>> >>> What or where did I mess up? >>> >>> Cheers Christoph >>> >>> >>> Original-Nachricht >>>> Datum: Mon, 01 Dec 2008 21:14:29 +0100 >>>> Von: Thomas Baier <[EMAIL PROTECTED]> >>>> An: "R (D)COM and RExcel server related issues" >> >>>> Betreff: Re: [Rcom-l] R (D)COM Server >>>> Christoph Hamer schrieb: >>>>> Hi, >>>>> >>>>> i am interested in using R, Rexcel and an extra insurance package >>>> (either reserving or Chainladder). >>>>> Unfortunately I was not able to find the exe of the compulsory R >> (D)COM >>>> Server. >>>>> The only thing i can find is a not working link to >>>>> >>>>> >> http://rcom.univie.ac.at/download/RAndFriends.distro/RAndFriendsSetup2072V3.0-3.exe >> >>>>> on >>>>> >>>>> >> http://learnserver.csd.univie.ac.at/rcomwiki/doku.php?id=rexcel_as_an_r_package >>>>> R is so cool and would be so much more powerfull if i coult use it >> with >>>> Excel together. >>>> >>>> Try http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe >>>> >>>> and install the package RExcelInstaller from within R. >>>> >>>> Thomas >>>> >>>> ___ >>>> 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.176 / Virus Database: 270.9.12/1823 - Release Date: >> 12/1/2008 7:59 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 > > > > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.176 / Virus Database: 270.9.12/1823 - Release Date: 12/1/2008 > 7:59 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
RE: [Rcom-l] R (D)COM Server
Hi, I think I have the same problem. When I Open Excel I receive the following message: "Object library invalid or contains references to object definitions that could not be found" If I have a look at the Tools>Reference Menu than the reference RExcelLib.xla cannot be found in the reference list. I also have listed the following reference which is not checked "UNSAVED: VbaProject". The RExcel button is not visible, but all code for the project "RExcelVBAlib" is available. I think the problem is situated with the reference "Microsoft Forms 2.0 Object Library" which is checked and cannot be removed. This dll "FM20.dll" is not really necessary in my opinion, except when it has something to do with the clipboard. The strange thing is that Rexcel doesn't work when I'm on the network, but it does when I work locally. And it does work if I log-on on another computer. Help please! Because we're in serious trouble. Thx Bert ___ 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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: 02 December 2008 15:06 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] R (D)COM Server Do you have a full installation of Excel or only a standard installation? When you start Excel now, do you get the RExcel menu? If yes, got into RExcel -> About and click copy to clipboard and then paste the clipboard content in an email you send to the list. Christoph Hamer wrote: > Hi > > I did as recommended: > > - download R 2.8.0 > - download and execute http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe > - install Rexcel from R > > If i try to open rexcel it dies and I get strange error messages (sorry its german): > > "Kompilierungsfehler in verborgenem Modul ThisWorkbook" > > Afterwards the Programm tells me: > > "RExcel is now configured for Excel 2003" > > "Fehler beim Kompilieren die Objektbibliothek ist ungültig oder enthällt Verweise Objektdefinitionen, die nicht gefunen werden konnten." > > I am a puzzeled since i just followed the instructions below. > > What or where did I mess up? > > Cheers Christoph > > > ---- Original-Nachricht ---- >> Datum: Mon, 01 Dec 2008 21:14:29 +0100 >> Von: Thomas Baier <[EMAIL PROTECTED]> >> An: "R (D)COM and RExcel server related issues" >> Betreff: Re: [Rcom-l] R (D)COM Server > >> Christoph Hamer schrieb: >>> Hi, >>> >>> i am interested in using R, Rexcel and an extra insurance package >> (either reserving or Chainladder). >>> Unfortunately I was not able to find the exe of the compulsory R (D)COM >> Server. >>> The only thing i can find is a not working link to >>> >>> >> http://rcom.univie.ac.at/download/RAndFriends.distro/RAndFriendsSetup2072V3. 0-3.exe >>> on >>> >>> >> http://learnserver.csd.univie.ac.at/rcomwiki/doku.php?id=rexcel_as_an_r_pack age >>> R is so cool and would be so much more powerfull if i coult use it with >> Excel together. >> >> Try http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe >> >> and install the package RExcelInstaller from within R. >> >> Thomas >> >> ___ >> 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.176 / Virus Database: 270.9.12/1823 - Release Date: 12/1/2008 7:59 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
Re: [Rcom-l] R (D)COM Server
Thank you for your fast reply My Excel edition came with "MS Office Professional Edition 2003" so i guess its a full installation. If i start Excel there is no RExcel button but i get the error messages described below. Original-Nachricht > Datum: Tue, 02 Dec 2008 15:05:51 +0100 > Von: Erich Neuwirth <[EMAIL PROTECTED]> > An: "R (D)COM and RExcel server related issues" > > Betreff: Re: [Rcom-l] R (D)COM Server > Do you have a full installation of Excel or only a standard installation? > > When you start Excel now, do you get the RExcel menu? > > If yes, got into RExcel -> About > and click copy to clipboard and then paste the clipboard content in an > email you send to the list. > > > > > > Christoph Hamer wrote: > > Hi > > > > I did as recommended: > > > > - download R 2.8.0 > > - download and execute > http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe > > - install Rexcel from R > > > > If i try to open rexcel it dies and I get strange error messages (sorry > its german): > > > > "Kompilierungsfehler in verborgenem Modul ThisWorkbook" > > > > Afterwards the Programm tells me: > > > > "RExcel is now configured for Excel 2003" > > > > "Fehler beim Kompilieren die Objektbibliothek ist ungültig oder > enthällt Verweise Objektdefinitionen, die nicht gefunen werden konnten." > > > > I am a puzzeled since i just followed the instructions below. > > > > What or where did I mess up? > > > > Cheers Christoph > > > > > > Original-Nachricht > >> Datum: Mon, 01 Dec 2008 21:14:29 +0100 > >> Von: Thomas Baier <[EMAIL PROTECTED]> > >> An: "R (D)COM and RExcel server related issues" > > >> Betreff: Re: [Rcom-l] R (D)COM Server > > > >> Christoph Hamer schrieb: > >>> Hi, > >>> > >>> i am interested in using R, Rexcel and an extra insurance package > >> (either reserving or Chainladder). > >>> Unfortunately I was not able to find the exe of the compulsory R > (D)COM > >> Server. > >>> The only thing i can find is a not working link to > >>> > >>> > >> > http://rcom.univie.ac.at/download/RAndFriends.distro/RAndFriendsSetup2072V3.0-3.exe > > >>> on > >>> > >>> > >> > http://learnserver.csd.univie.ac.at/rcomwiki/doku.php?id=rexcel_as_an_r_package > >>> R is so cool and would be so much more powerfull if i coult use it > with > >> Excel together. > >> > >> Try http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe > >> > >> and install the package RExcelInstaller from within R. > >> > >> Thomas > >> > >> ___ > >> 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.176 / Virus Database: 270.9.12/1823 - Release Date: > 12/1/2008 7:59 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 -- Pt! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger ___ 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
Re: [Rcom-l] R (D)COM Server
Do you have a full installation of Excel or only a standard installation? When you start Excel now, do you get the RExcel menu? If yes, got into RExcel -> About and click copy to clipboard and then paste the clipboard content in an email you send to the list. Christoph Hamer wrote: > Hi > > I did as recommended: > > - download R 2.8.0 > - download and execute > http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe > - install Rexcel from R > > If i try to open rexcel it dies and I get strange error messages (sorry its > german): > > "Kompilierungsfehler in verborgenem Modul ThisWorkbook" > > Afterwards the Programm tells me: > > "RExcel is now configured for Excel 2003" > > "Fehler beim Kompilieren die Objektbibliothek ist ungültig oder enthällt > Verweise Objektdefinitionen, die nicht gefunen werden konnten." > > I am a puzzeled since i just followed the instructions below. > > What or where did I mess up? > > Cheers Christoph > > > Original-Nachricht >> Datum: Mon, 01 Dec 2008 21:14:29 +0100 >> Von: Thomas Baier <[EMAIL PROTECTED]> >> An: "R (D)COM and RExcel server related issues" >> >> Betreff: Re: [Rcom-l] R (D)COM Server > >> Christoph Hamer schrieb: >>> Hi, >>> >>> i am interested in using R, Rexcel and an extra insurance package >> (either reserving or Chainladder). >>> Unfortunately I was not able to find the exe of the compulsory R (D)COM >> Server. >>> The only thing i can find is a not working link to >>> >>> >> http://rcom.univie.ac.at/download/RAndFriends.distro/RAndFriendsSetup2072V3.0-3.exe >> >>> on >>> >>> >> http://learnserver.csd.univie.ac.at/rcomwiki/doku.php?id=rexcel_as_an_r_package >>> R is so cool and would be so much more powerfull if i coult use it with >> Excel together. >> >> Try http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe >> >> and install the package RExcelInstaller from within R. >> >> Thomas >> >> ___ >> 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.176 / Virus Database: 270.9.12/1823 - Release Date: 12/1/2008 > 7:59 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
Re: [Rcom-l] R (D)COM Server
Hi I did as recommended: - download R 2.8.0 - download and execute http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe - install Rexcel from R If i try to open rexcel it dies and I get strange error messages (sorry its german): "Kompilierungsfehler in verborgenem Modul ThisWorkbook" Afterwards the Programm tells me: "RExcel is now configured for Excel 2003" "Fehler beim Kompilieren die Objektbibliothek ist ungültig oder enthällt Verweise Objektdefinitionen, die nicht gefunen werden konnten." I am a puzzeled since i just followed the instructions below. What or where did I mess up? Cheers Christoph Original-Nachricht > Datum: Mon, 01 Dec 2008 21:14:29 +0100 > Von: Thomas Baier <[EMAIL PROTECTED]> > An: "R (D)COM and RExcel server related issues" > > Betreff: Re: [Rcom-l] R (D)COM Server > Christoph Hamer schrieb: > > Hi, > > > > i am interested in using R, Rexcel and an extra insurance package > (either reserving or Chainladder). > > Unfortunately I was not able to find the exe of the compulsory R (D)COM > Server. > > > > The only thing i can find is a not working link to > > > > > http://rcom.univie.ac.at/download/RAndFriends.distro/RAndFriendsSetup2072V3.0-3.exe > > > > > on > > > > > http://learnserver.csd.univie.ac.at/rcomwiki/doku.php?id=rexcel_as_an_r_package > > > > R is so cool and would be so much more powerfull if i coult use it with > Excel together. > > Try http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe > > and install the package RExcelInstaller from within R. > > Thomas > > ___ > 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 -- Pt! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger ___ 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
Re: [Rcom-l] R (D)COM Server
Christoph Hamer schrieb: Hi, i am interested in using R, Rexcel and an extra insurance package (either reserving or Chainladder). Unfortunately I was not able to find the exe of the compulsory R (D)COM Server. The only thing i can find is a not working link to http://rcom.univie.ac.at/download/RAndFriends.distro/RAndFriendsSetup2072V3.0-3.exe on http://learnserver.csd.univie.ac.at/rcomwiki/doku.php?id=rexcel_as_an_r_package R is so cool and would be so much more powerfull if i coult use it with Excel together. Try http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe and install the package RExcelInstaller from within R. Thomas ___ 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
