Excel object not released

Is there any program that can detect how many references an object (in this case, excel) has?

I have a VB app that opens Excel, opens hundreds of workbooks (1 at a time) then exits. The Excel object that I create does not get released when the app ends, even though I do this: "set ExcelApp = nothing". I am using the Task Manager to watch as Excel is created, but never released.

tia,

flynn

Hello!

Are you also calling ExcelApp.Quit as well as closing your Workbook/Workbooks objects?

Also I recommend to use GetObject(,"Excel.Application") before to open a new Excel instance to get the current instance opened, if is there, if not have any excel instance opened then use:
Set ExcelApp = New Excel.Application or Set ExcelApp = CreateObject ("Excel.Application")

I hope help

That was it Syko. I stared at it, but didn't see it. Thank you.

no problem! Glad you figured it out :)