Remove add in from inactive list excel 2007

[Teddy]

Hi group

How do I with vba remove add in from inactive list of add ins.
I have uninstalled the add in but it still appears in inactive list

Cheers

 

[Peter T]

If the addin is in the default addins folder remove the addin (don't just
rename it).

If the addin is in some other location, remove or rename the addin. Restart
Excel, attempt to re-install the addin in the addin manager dialog, ie tick
the box. A message will say the addin is not found and ask if you want to
remove it from the list, click yes.

Regards,
Peter T

 

[Leon]

If the addin is in the default addins folder remove the addin (don't just
rename it).

If the addin is in some other location, remove or rename the addin. Restart
Excel, attempt to re-install the addin in the addin manager dialog, ie tick
the box. A message will say the addin is not found and ask if you want to
remove it from the list, click yes.

Regards,
Peter T








- Vis tekst i anførselstegn -

Is there a way to do this by VBA?

 

[Peter T]

If the addin is in a default addins folder simply use the Name method to
move the file into a different folder.

If the addin is elsewhere the only programmatic way is to delete the entry
from this key in the registry -

HKEY_CURRENT_USER\Software\Microsoft\Office\version\Excel\Add-in Manager

(assuming it was uninstalled last Excel session)

Regards,
Peter T

 

[john]

If you have deleted the addin & want to remove it from the addin manager
list, only way I know to do this is to use sendkeys to imitate user doing
this manually.

Try this procedure & see if it will do what you are looking for:


Sub CleanAddinList()
Dim AddinCount As Long
Dim GoUpandDown As String
'Turn display alerts off so user is
'not prompted to remove Addin from list
With Application
.DisplayAlerts = False

Do
'Count of all AddIns
AddinCount = Application.AddIns.Count

'Create string for SendKeys that will move up & down
'AddIn Manager List
'Any invalid AddIn listed will be removed
GoUpandDown = "{Up " & AddinCount & "}{DOWN " & AddinCount & "}"

Application.SendKeys GoUpandDown & "~", False
Application.Dialogs(xlDialogAddinManager).Show

'Continue process until all invalid AddIns are removed
'code will only remove one at a time.
Loop While AddinCount <> Application.AddIns.Count
.DisplayAlerts = True

End With
End Sub

hope helpful

 

[Leon]

If the addin is in a default addins folder simply use the Name method to
move the file into a different folder.

If the addin is elsewhere the only programmatic way is to delete the entry
from this key in the registry -

HKEY_CURRENT_USER\Software\Microsoft\Office\version\Excel\Add-in Manager

(assuming it was uninstalled last Excel session)

Regards,
Peter T








- Vis tekst i anførselstegn -

Great thanks

 

[Leon]

If you have deleted the addin & want to remove it from the addin manager
list, only way I know to do this is to use sendkeys to imitate user doing
this manually.

Try this procedure & see if it will do what you are looking for:

Sub CleanAddinList()
    Dim AddinCount As Long
    Dim GoUpandDown As String
    'Turn display alerts off so user is
    'not prompted to remove Addin from list
    With Application
        .DisplayAlerts = False

        Do
            'Count of all AddIns
            AddinCount = Application.AddIns.Count

            'Create string for SendKeys that will move up & down
            'AddIn Manager List
            'Any invalid AddIn listed will be removed
            GoUpandDown = "{Up " & AddinCount & "}{DOWN " &AddinCount & "}"

            Application.SendKeys GoUpandDown & "~", False
            Application.Dialogs(xlDialogAddinManager).Show

            'Continue process until all invalid AddIns are removed
            'code will only remove one at a time.
        Loop While AddinCount <> Application.AddIns.Count
        .DisplayAlerts = True

    End With
End Sub

hope helpful
--
jb







- Vis tekst i anførselstegn -

Really great :-D

Can I ask you guys if you know a way to install and NOT having a
dialogbox showing up asking if I want to copy to my user folder.
The answer should here be NO. (i don't want to copy)