Releasing .NET Automation Addins for MS Excel

[helix]

Hi,

I have a question about .NET automation addins for MC Office and Excel in particular. I have created a C# automation addin for Excel by using a COM interop wrapper - along the lines of:

http://blogs.msdn.com/eric_carter/ar...01/273127.aspx

The addin works great. However, my problem appears when I try to release the add-in. In the past I've used XLLs and was able to load and release the addin on the fly by simply unchecking the addin from the tools>add-ins menu. this is really handy when you need to recompile. Unfortunately I don't seem to be able to achieve the same behaviour for my automation addin. Does anyone know how to release/unload?

Any help much appreciated !! Thanks

[helix]

i'm still struggling with this - please please someone help me

[yhilewitz]

Try the following:
Include the Excel COM object into your project.
In code:
//Initialize Excel
Excel._Application App;
App = (Excel._Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Applicat ion");
//do your work
....
//To release Excel
int z;
do
{
z = System.Runtime.InteropServices.Marshal.ReleaseComObject(App);
}
while (z != 0);
App = null;