Execute a button from third party com add-In

[abc_xyz]

I have installed a third party com add-in. It is a .vsto file format. The add-in has a Refresh All button. I want to execute that using VBA.
Is this even possible?

 

[Rijnsent]

If that button has a shortcut key you could send that as command from VBA (Sendkey).

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Execute a button from ribbon

I have a com add-in installed on my system and I want to execute the Refresh All button from that add-in. It is a .vsto file format and also I do not have the button id. Is this something doable with the help of VBA...

chandoo.org

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[abc_xyz]

It has to be dynamic so that it works for all the users. The position of the add-in may or may not be same for everyone.

If that button has a shortcut key you could send that as command from VBA (Sendkey).

 

[Colin Legg]

It is likely that the add-in vendor has exposed a COM call which you can invoke from VBA and will do the same thing as clicking on the ribbon button, eg. Application.Run "SomeNameInHere".

This will be the most straightforward option for you but the trick is knowing what name to use and whether any arguments need to be passed in. For example, Bloomberg has one called "RefreshAllWorkbooks". If you tell us what the add-in is, we might know it or be able to help you search; alternatively you could contact the vendor and ask them.

 

[abc_xyz]

It is likely that the add-in vendor has exposed a COM call which you can invoke from VBA and will do the same thing as clicking on the ribbon button, eg. Application.Run "SomeNameInHere".

This will be the most straightforward option for you but the trick is knowing what name to use and whether any arguments need to be passed in. For example, Bloomberg has one called "RefreshAllWorkbooks". If you tell us what the add-in is, we might know it or be able to help you search; alternatively you could contact the vendor and ask them.

It is Dealogic excel plugin. I did try using some combinations for the COM call method but it did not work.

 

[Colin Legg]

It is Dealogic excel plugin. I did try using some combinations for the COM call method but it did not work.

I'm not familiar with Dealogic so I'm afraid I can't help further. If there isn't any info in their documentation I would try contacting their helpdesk to see if there is a call available as that would be the easiest option.

It is possible to access and trigger ribbon components via the IAccessible interface, but that's a more complicated piece of work...

 

[abc_xyz]

I'm not familiar with Dealogic so I'm afraid I can't help further. If there isn't any info in their documentation I would try contacting their helpdesk to see if there is a call available as that would be the easiest option.

It is possible to access and trigger ribbon components via the IAccessible interface, but that's a more complicated piece of work...

Can this be done using UI Automation Library? If yes, could you please help me as I have zero knowledge about it?

 

[Jaafar Tribak]

It should be possible to do this using the IAccessible Interface as suggested by Colin or using UI Automation.

What is the caption of this 3rd party addin button ? And, Is it a separate Tab like for example the Home Tab or is it a button under a Tab ?
If you post a screenshot of it, it should help us find a solution.

 

[abc_xyz]

It should be possible to do this using the IAccessible Interface as suggested by Colin or using UI Automation.

What is the caption of this 3rd party addin button ? And, Is it a separate Tab like for example the Home Tab or is it a button under a Tab ?
If you post a screenshot of it, it should help us find a solution.

Yes, it is a separate tab just like Home Tab. The tab is called Dealogic (caption). Under that tab there are multiple groups. Every group has multiple buttons inside it. The group name Refresh has the Refresh All button. Unfortunately, Im not allowed to post any snapshots. I hope this helps.