http://support.microsoft.com/default...b;en-us;178510
PRB: Excel Automation Fails Second Time Code Runs

http://support.microsoft.com/default...b;EN-US;189618
PRB: Automation Error Calling Unqualified Method or Property


http://support.microsoft.com/?kbid=199219
XL2000: Automation Doesn't Release Excel Object from Memory


--
Regards,
Tom Ogilvy

"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