View Single Post
  #1   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
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