Hi!

I don't know if anyone can help with this but when I run my application to automate excel, the excel session will close only when the userform is disposed (it stays open in memory). This isn't very helpful as it means that you can't perform other functions on the form which may require re-opening the excel file which is already open. You would have to close the form and re-open it in order to run other functions displayed there.

I have no idea why this is occurring. As far as I can see all the COM objects are dereferenced properly (all set to nothing - range objects, worksheet objects, workbook objects and then the application is quit and the application object itself is set to nothing) so I can't see what is keeping excel open. Anyone any ideas why excel might stay open until the form is disposed? Is there something I don't know about?!

Thanks,

JF