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

--
Christian Asseburg, PhD
Bayesian Statistician
IHE - Swedish Institute for Health Economics
mail: Box 2127, 22002 Lund, Sweden
email: [EMAIL PROTECTED]
tel: +4646329109
mob: +46733401477
fax: +4646121604
www: http://www.ihe.se/personal/ca_eng.htm

_______________________________________________
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

Reply via email to