List Add-In Manager dialog box and activate or desactivate (1 Viewer)

[Superpat]

Hello,
I want to list Add-In Manager dialog box and know is some elements are activate.

After, Activate and desactivate, here for VBA MZ-Tools .

Thanks to help

 

[Josef P.]

Dim AddInRef As VBIDE.AddIn

For Each AddInRef In VBE.Addins
    With AddInRef
        Debug.Print .ProgId, .Description, .Connect
    End With
Next

 

[isladogs]

Thanks Josef
That was very simple!
Do you also have similar code for Access and COM add-ins?

 

[Superpat]

Dim AddInRef As VBIDE.AddIn

For Each AddInRef In VBE.Addins
    With AddInRef
        Debug.Print .ProgId, .Description, .Connect
    End With
Next

Sorry @Josef P. I have a problem

 

[Josef P.]

VBIDE require reference 'Microsoft Visual Basic for Application Extensibility"
=> Application.References.AddFromGuid "{0002E157-0000-0000-C000-000000000046}", 5, 3
Or you can use late binding:
Dim AddInRef As Object

Do you also have similar code for Access and COM add-ins?

It is almost the same for COM add-ins.

Dim ComAddIn As Office.ComAddIn

For Each ComAddIn In Access.COMAddIns
    With ComAddIn
        Debug.Print .ProgId, .Description, .Connect
        ' .Connect ... enabled/disabled in COM-add-in list (Access Options)
    End With
Next

I am not aware of any property for Access add-ins.
These are also never loaded at startup, but are only loaded on the 1st call. After that they are available as VBProject.

 

[Superpat]

VBIDE require reference 'Microsoft Visual Basic for Application Extensibility"
=> Application.References.AddFromGuid "{0002E157-0000-0000-C000-000000000046}", 5, 3

Thanks, It work nice. I will try tomorrow next... and to change False in true

 

[isladogs]

Thanks for the COM add-ins code.

I had also searched unsuccessfully for code related to Access add-ins.
This lists all loaded projects including loaded add-ins

Sub ListLoadedProjectPaths()
    Dim proj
    For Each proj In VBE.VBProjects
        Debug.Print proj.FileName
    Next proj
End Sub

It doesn't include installed add-ins that aren't loaded.

To get a list of all Access add-ins, I currently search the registry path:
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Menu Add-Ins