View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Gérard Ducouret Gérard Ducouret is offline
external usenet poster
 
Posts: 15
Default Excel instances remain opened

Hello guys !
Thanks all of you for your answers !

Gérard

"Simon Murphy" a écrit dans le message de
...
Gérard
You are not quitting Excel
Try
xlapp.workbooks.close
xlapp.quit
set xlapp = nothing

note workbooks.close is going to throw up a msgbox to save changes
better to use
xlapp.worksbooks(1).close savechanges:=true (or false)
cheers
Simon

"Gérard Ducouret" wrote in message
...
Hello
I'm trying to create a new instance of Excel (from MS Project) with the
following :

Set XLApp = New Excel.Application
If XLApp Is Nothing Then
Set XLApp = New Excel.Application
End If

then to close it by :
XLApp.Workbooks.Close
Set XLApp = Nothing

but all the Excel instances remain opened : in the Tasks Manager of Win
2000
I have as many EXCEL instances than I ran the macro.

Thanks for help,

Gérard Ducouret