Is there a way to write a command that will trigger a specific macro in Microsoft Excel?

Yes, there is. I don't use Excel much, so don't have an example directly from my files, but I use Word a fair amount, or at least used to, and the code should be almost identical.

You need to include an object reference to the Microsoft Excel Object Library. In the MyCommands Editor, press alt plus enter and then scroll down until you see Microsoft Excel listed, and check that. Then, either paste your VBA code for the macro in question, or alternatively, try this line:

Excel.Application.Run(name of macro in Excel)

Hope this helps.

Matt

A quick way to voice-enable an Excel macro is to add the macro to the Quick Access Toolbar, and rename the QAT macro to something that Dragon can easily recognize. For example, rename the macro "Hello there".

As long as the macro appears on the QAT, you can activate it by saying "click Hello there".

Thanks. This worked great.  The only problem is that the icon Excel assigns to it is too large. Is there a way to eliminate, change, or shrink the non text part of the icon?

Not sure which technique you're using, but assuming it's the QAT approach...

 

Excel Options > Quick Access Toolbar

 

If you click the "Modify..." button, you can rename the macro, and you can choose a different icon for the macro. Some icons might be smaller or less conspicuous than the default. But I haven't checked.

Another quick way of doing it is to add a hotkey to the Excel macro, and then execute the hotkey in Dragon via SendKeys; at the cost of spending yet another hotkey. Therefore, I prefer the approach which Matt has outlined.


-------------------------

No need to buy if all you want to do is try ...

DragonCapture KB Download (Latest)
DragonCapture Homepage