Re: [Rcom-l] Update to R2.8.0: Can't copy Excel Worksheet

2008-10-31 Thread Christian Asseburg
I can confirm that now it works! Thank you! . . Christian On Thu, 30 Oct 2008 13:47:57 +0100, Erich Neuwirth <[EMAIL PROTECTED]> wrote: rscproxy 1.0-12 is out and will appear on your CRAN mirrors soon (Thanks Thomas!) Not Christian Asseburg's example works! library(rcom) E<-comCreateObjec

Re: [Rcom-l] Update to R2.8.0: Can't copy Excel Worksheet

2008-10-30 Thread Erich Neuwirth
rscproxy 1.0-12 is out and will appear on your CRAN mirrors soon (Thanks Thomas!) Not Christian Asseburg's example works! library(rcom) E<-comCreateObject("Excel.Application") E[["Visible"]]<-TRUE W1<-E[["Workbooks"]]$Add() S1<-E[["ActiveSheet"]] W2<-E[["Workbooks"]]$Add() S1$Copy(Before=W2[["Wor

Re: [Rcom-l] Update to R2.8.0: Can't copy Excel Worksheet

2008-10-23 Thread Christian Asseburg
Hej Erich - What I did was: Uninstall R2.7.2, install R2.8.0, load package "rcom" from CRAN, then the code below. That way, it crashed R on the last statement. Now, I followed your suggestion and ran comRegisterRegistry(), and the code below does not crash any more. But it seems it is ignorin

Re: [Rcom-l] Update to R2.8.0: Can't copy Excel Worksheet

2008-10-22 Thread Thomas Baier
Erich & Christian, maybe there is a problem with optional arguments to methods. I will check this with your example. In principle, passing objects as arguments should be fine, as long as the objects are IDispatch. Thomas Erich Neuwirth schrieb: I ran your code in R 2.8.0 and it worked (did

Re: [Rcom-l] Update to R2.8.0: Can't copy Excel Worksheet

2008-10-22 Thread Erich Neuwirth
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

Re: [Rcom-l] Update to R2.8.0: Can't copy Excel Worksheet

2008-10-22 Thread Christian Asseburg
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 - . .

RE: [Rcom-l] Update to R2.8.0: Can't copy Excel Worksheet

2008-10-22 Thread Wayne.W.Jones
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 --