I ran your code in R 2.8.0 and it worked (did not crash but it ptobably also did not do what you wanted. Please explain what you want.
Did you install the version of rcom compiled for R-2.8.0? Did you run comRegisterRegistry() after installing the new version? Christian Asseburg wrote: > Dear Wayne, thanks, I might have to do that. > > I noticed that R 2.8.0 also crashes with a command like > > Chartobject$SetSourceData(Source=range, PlotBy=plotby.value) > > so I suspect that the crash has something to do with passing rcom > objects as arguments to rcom functions. > > With best wishes - > > . . Christian > > On Wed, 22 Oct 2008 16:05:36 +0200, <[EMAIL PROTECTED]> wrote: > >> >> Hi Christian, >> >> There are some big changes to R in version R 2.8.0. >> Apparently some of the dll files in the core R distribution have changed >> and rcom hasnt been updated to accomodate these yet (Erich, Thomas >> correct me if I am wrong). >> >> I would revert back to R.7.2 for now. >> >> Regards, >> >> Wayne >> >> >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] Behalf Of Christian >> Asseburg >> Sent: 22 October 2008 13:17 >> To: rcom-l@mailman.csd.univie.ac.at >> Subject: [Rcom-l] Update to R2.8.0: Can't copy Excel Worksheet >> >> >> Dear RCOM list - >> >> I've been using rcom since R version 2.5.1 to read and manipulate >> workbooks in Excel. It's great to have this facility with rcom and R! >> >> The following lines in my code worked fine with up to R 2.7.2 but in R >> 2.8.0 they result in a crash of R. Does anyone know why, and how to fix >> this? >> >> library(rcom) >> E<-comCreateObject("Excel.Application") >> W1<-E[["Workbooks"]]$Add() >> S1<-E[["ActiveSheet"]] >> W2<-E[["Workbooks"]]$Add() >> S1$Copy(Before=W2[["Worksheets",1]]) >> >> If I just write S1$Copy() it works but I want the worksheet as a copy in >> W2, not in a new workbook. >> >> I'm using R 2.8.0 with Windows XP (Service pack 3), and rcom is installed >> by downloading the package from CRAN using the R menu. My Excel >> version is >> Excel 2000, version 9.0.6926 SP-3. >> >> Thanks for help. With best wishes - >> >> . . Christian >> > > > > > ------------------------------------------------------------------------ > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.175 / Virus Database: 270.8.2/1738 - Release Date: 10/21/2008 > 2:10 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
