I've been wrestling with Excel objects through VB for quite a while - and can't seem to resolve one thing.
When I create an excel object from VB, and then create a workbook within it, it works fine. But when the user closes the worksheet, the entire Excel Application disappears - and sits in the background, gobbling up resources. I have to go into Win NT Task Manager to kill it.
I've heard there is some kind of "flag" on either the Excel.Application object, or the Excel.Worksheet object that will stop this happening - but I can't find it.
This is a major problem, so I'd really appreciate any help,
thanks in advance,