[R] RCOM Save

[Henrique Dallazuanna]

Try this;




On Thu, Apr 1, 2010 at 7:00 AM, koj <jens.koch at gmx.li> 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[['DisplayAlerts']] <- 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[['Save']] <- TRUE
xl$Quit()
xl <- NULL
gc(reset = TRUE)
#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.
> --
> View this message in context: http://n4.nabble.com/RCOM-Save-tp1746602p1747885.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>



-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O