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@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.
