#1
|
|||
|
|||
Using VBA to enable a COM ADD-IN
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. |
#2
|
||||
|
||||
Security may prevent this from working, but in theory the following should work
Code:
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
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
dragon naturallyspeaking |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA code to enable a Word COM Add-In | wordguy | Word VBA | 11 | 06-16-2017 12:26 PM |
Help with Word VBA code to enable a COM Add-In | wordguy | Word VBA | 0 | 06-13-2017 01:52 PM |
enable and disable macro | MANOHAR | Word VBA | 2 | 01-14-2017 02:55 PM |
Force a user to enable macros in Powerpoint? Hide sheets until the "enable" button is clicked | copleyr | PowerPoint | 1 | 10-07-2016 01:15 AM |
How to enable PowerPoint Macros? | delete123 | PowerPoint | 3 | 03-27-2012 06:56 AM |