[R] rcom close Excel problem

[stephen bond]

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