I am trying to use Excel and OLE automation. I am using MSAcess to generate a spreadsheet, and then Excel to import it and format it, etc. What happens is that the forms rule applies, and for some reason, though I close the Excel application, there is a reference left and the File remains locked.

I want to know if there is anyway to know if an OLE invoked object has any references left, and if I can clean up the references (using IReleaseReference or some similar process). Anyone using Excel and OLE automation has probably run up against this so please HEEEEEEEELP......


Thanks,
Nikhil