Message-ID: <2983390.1197662328437.JavaMail.?@fh128.dia.he.tucows.com>
Date: 2007-12-14T19:58:48Z
From: Stephen Bond
Subject: rcom close Excel problem
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