Hi Jay,
Has anyone seen this before? Is there anything special that needs to be
done when invoking VB.Net objects from Excel macros to allow a clean exit?
Sorry, but I've no idea. The only thing I can think of is that the .NET
objects have yet to be garbage-collected when Excel is closing down, so you
might be triggering an event in one of your classes that's calling into
Excel after it's shut down VBA. To test that, you could try adding an
explicit Dispose method in your .Net objects, which is called by Excel prior
to setting them to nothing. In the Dispose method, you'd explicitly turn off
the timer/event raising.
If that doesn't help, the people that know about Excel/.Net integration hang
out in the Public.vsnet.vstools.office newsgroup, so you might get a more
informed response if you ask your question there.
Regards
Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk