Using VBA to enable a COM ADD-IN

[Darin Park]

Hi guys. This is driving me crazy. I use Dragon NaturallySpeaking with Word quite a bit, however, Word was taking a hit on load up by the Nuance COM ADD-IN. I disable the add-in and only turned it on whenever I needed it. But it's a five mouse click operation that takes me out of my document and interrupts my workflow. I tried using macro recorder to capture my keystrokes of enabling the ADD-IN, but the macro recorder won't capture those keystrokes and mouse clicks to enable the ADD-IN.



So, my question is this. I don't know how to write the code for it so do any of you know how to write a code to:

(1) Click on File
(2) Click on Options
(3) Click on Add-Ins
(4) Click on COM Add-ins (and then the Go... button)
(5) Click on the tick box for the add-in and then click OK.

I know how to add that macro to the taskbar once coded so it's a single click. I just don't know how to code that in the first place.

[gmayor]

Security may prevent this from working, but in theory the following should work

Sub Macro1()
Dim oAddIn As COMAddIn
    For Each oAddIn In Application.COMAddIns
'Debug.Print oAddIn.Description
        If oAddIn.Description Like "*Dragon*" Then
            oAddIn.Connect = Not oAddIn.Connect
            Exit For
        End If
    Next oAddIn
End Sub