[R] rcom close Excel problem

From: stephen bond <stenka1_at_go.com>
Date: Fri, 14 Dec 2007 19:58:48 +0000 (UTC)


Hello,

I just discovered that I cannot close the Excel application and task manager shows numerous copies of Excel.exe

I tried both

x$Quit() # shown in the rcom archive

and

x$Exit()

and Excel refuses to die.
Thank you very much.
S.

"You can't kill me, I will not die" Mojo Nixon

I also have a problem with saving. It produces a pop-up dialog and does
not take my second parameter:

x<-comCreateObject("Excel.Application")
wb<-comInvoke(comGetProperty(x,"Workbooks"),"Open","G: /MR/Stephen/repo.
xls", "0")
sh<-comGetProperty(wb,"Worksheets","Market Data") range1 <- comGetProperty(sh,"Range","C10","I11") vals <- comGetProperty(range1,"Value")
comInvoke(wb,"Close","G:/MR/Stephen/repo.xls","True") # True is ignored

Thank you All.
Stephen



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. Received on Fri 14 Dec 2007 - 20:01:45 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Sat 15 Dec 2007 - 11:30:19 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.