Invoke a COM addin option from VBA
Posted
by rip
on Stack Overflow
See other posts from Stack Overflow
or by rip
Published on 2010-04-27T16:32:07Z
Indexed on
2010/04/27
16:33 UTC
Read the original article
Hit count: 436
Can I invoke an option on a COM Add-in from a VBA macro in Word or Excel 2007? The COM Add-in was written using VSTO – it adds a custom ribbon tab with a number of options that I want to execute from a VBA macro.
- I can reference the add-in using Application.COMAddIns("MyAddinName") but I can’t find an option to invoke an option.
- I’ve also played around with the Application.CommandBars collection, and can see that you can execute an option using CommandBarControl.Execute but I can’t find my command bar in the Application.CommandBars collection.
Does anyone know if this is possible?
© Stack Overflow or respective owner
