Skip to content

rcom close Excel problem

3 messages · Stephen Bond, Charilaos Skiadas, Gyula

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
Charilaos Skiadas
# 
I know it won't answer your question exactly, but using comGetObject  
instead of comCreateObject won't create new Excel instances, so at  
least you won't have more than one processes running, so this might  
solve some of your problems.

As for your second problem, I would venture to guess you need your  
paths with double backslashes instead of slashes. The following just  
worked over here:

  wb<-comInvoke(comGetProperty(obj,"Workbooks"),"Open", "C:\ 
\Documents and Settings\\Haris\\Desktop\\test1.xlsx")

Haris Skiadas
Department of Mathematics and Computer Science
Hanover College
On Dec 14, 2007, at 2:58 PM, stephen bond wrote:

            

      
      
      
    

  
  


  


      

    

    

      
      

        


  

        

      Gyula
    

    

      
      #
    

  


  

      
First, you will likely have to use Ctrl-Alt-Delete - Task Manager - to
kill the Excel processes.

you could also try

 wb[["Saved"]]<-TRUE  # trick Excel to think that the workbook is
saved
 x$Quit() # close Excel
 rm(list=ls()) # remove all objects attached to environment

Gyula

        
On Dec 14, 11:58 am, stephen bond <sten... at go.com> wrote: