Updating Add-In via .NET

[dovh49]

When I update my add-in (I currently do this manually) I replace the old add-in file with the new one but when I do this excel doesn't recognize the new file. So I have to delete the old one go into excel and try to manually add the old add-in, which was deleted, tell it to get rid of the reference to the old one then I can put in the new add-in.

Is there a way to get around this? I've read Professional Excel Development and Excel 2010: Power Programming with VBA but neither address this problem and I haven't found any solutions online. What am I missing?

[westconn1]

why not just edit the existing addin?

[Siddharth Rout]

I replace the old add-in file with the new one

How and where do you replace it?

Sid

[dovh49]

What I normally do is I copy over the new file from my XP Office 2003 computer and paste it into the folder where I have the add-in file (not the add-ins folder but a separate folder near the excel file that I use it on). I then start the program using VB.NET that uses the following code:

If Not ContainsAddIn(oXl, "MyAddIn") Then
                        oAddin = oXl.AddIns.Add(gsMainAddInFullName, True)
                    End If
                    oAddin.Installed = True

Where ContainsAddIn is a function that checks if the add-in is already installed already (before I would always just use oXl.AddIns.Add always so the problem existed before I added this code).