Re: [R] RCOM Save

2010-04-03 Thread koj
Sorry. Of course you are right. I am using library(RDCOMClient). I tried the new suggestion which is the solution. Thank you. -- View this message in context: http://n4.nabble.com/RCOM-Save-tp1746602p1749968.html Sent from the R help mailing list archive at Nabble.com. _

Re: [R] RCOM Save

2010-04-01 Thread Erich Neuwirth
Please be more precise. You seem not to use the rcom (note the lowercase name) package, but the RDCOMClient package which is not available from CRAN but as part of the Omegahat project. rcom has a command comCreateObject and RDCOMClient has a command COMCreate. The code you supplied will definite

Re: [R] RCOM Save

2010-04-01 Thread Henrique Dallazuanna
Try this; On Thu, Apr 1, 2010 at 7:00 AM, koj wrote: > > Thank you. Unfortunately this recommendation does not solve my problem and I > don't know why. Here is my test-code: > > > pfad<-paste("C:/...","xls",sep=".") > xl <- COMCreate("Excel.Application") > xl[["Visible"]] <- FALSE xl[['Displa

Re: [R] RCOM Save

2010-04-01 Thread koj
Thank you. Unfortunately this recommendation does not solve my problem and I don't know why. Here is my test-code: pfad<-paste("C:/...","xls",sep=".") xl <- COMCreate("Excel.Application") xl[["Visible"]] <- FALSE wkbk <- xl$Workbooks()$Open(pfad) sh <- xl$ActiveShee

Re: [R] RCOM Save

2010-03-31 Thread Henrique Dallazuanna
Try adding this: y[["DisplayAlerts"]] <- FALSE On Wed, Mar 31, 2010 at 8:28 AM, koj wrote: > > Dear all, > > I use the package RCOM to manipulate Excel-Files (Windows). > > After opening the Excel-File and formatting the cells I want to save the > file automatically without request. If I use y[[

[R] RCOM Save

2010-03-31 Thread koj
Dear all, I use the package RCOM to manipulate Excel-Files (Windows). After opening the Excel-File and formatting the cells I want to save the file automatically without request. If I use y[["Save"]] <- TRUE it opens the saving dialog and I have to select the destination for saving. But I simpl