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 rcom-l@mailman.csd.univie.ac.at 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 rcom-l@mailman.csd.univie.ac.at 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
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 rcom-l@mailman.csd.univie.ac.at 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
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 rcom-l@mailman.csd.univie.ac.at 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 rcom-l@mailman.csd.univie.ac.at 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
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 rcom-l@mailman.csd.univie.ac.at 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 rcom-l@mailman.csd.univie.ac.at 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