RCOM Save

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$ActiveSheet()
A3R <- sh$Range("A28")
A3R[["Formula"]] <- "=Summe(A1:A27)"
A3RF <- A3R$Font()
A3RF[["Bold"]] <- TRUE

I tried a lot of possibilities (e. g. in the close statement) but without
success. Excel always asks about the saving.
--
View this message in context: http://n4.nabble.com/RCOM-Save-tp1746602p1747885.html
Sent from the R help mailing list archive at Nabble.com.

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$ActiveSheet()
A3R <- sh$Range("A28")
A3R[["Formula"]] <- "=Summe(A1:A27)"
A3RF <- A3R$Font()
A3RF[["Bold"]] <- TRUE
wkbk$Close(pfad)
system("taskkill /f /im Excel.exe")

I tried a lot of possibilities (e. g. in the close statement) but without
success. Excel always asks about the saving.