How to kill an addin.

[Giordano Bruno]

I have the following code:
AddinTitle = "ACME"
AddIns(AddinTitle).Installed = False
Kill Application.UserLibraryPath & AddinName
This works up to a point, but the ACME addin still appears in the Addins list. Sure it goes when you try to tick it, but I would like all trace of the addin to disappear after the code has been run. Is this possible?

 

[Andrew Poulsom]

You could try using SendKeys to dismiss the dialog that appears when you try to instal a non-existent Add-In.

 

[Giordano Bruno]

Thanks for that Andrew. I have incorporated send keys to do the equivalent of Alt-t i, but how do I then select the correct Addin? It seems that there is still some human intervention required.

 

[Andrew Poulsom]

Isn't it?

AddIns(AddinTitle).Installed = True

 

[Giordano Bruno]

Hi Andrew,

That looks like a good suggestion, but I can't make it work. After killing the addin I have the code:
SendKeys ("%t")
SendKeys ("i")
AddIns(AddinTitle).Installed = True
SendKeys "{ENTER}"

Then when I look at my addins list, its still there. Can you see if I am doing anything wrong?

 

[Andrew Poulsom]

It seems that programmatically trying to install a non-existent Add-In doesn't fail and cause the dialog to appear. So I think you are out of luck.

 

[Giordano Bruno]

Thanks for you help Andrew.

It is very much appreciated. I guess if you can't make it work I might as well stop trying.