get access to add-in via vba

[Hans810]

I would like to access the add-in commands from our ERP software (Exact Software) via VBA in an excel sheet, in which I have put an SQL querie. The green add-in button starts (extra icon in the top toolbar) the SQL querie. Pls help! Thanks in advance.
Regards from Holland, Hans

 

[Colin Legg]

What sort of add-in is it? xla? dll? Starting point is to add a reference to it in your VBA project so you can write your code with the benefit of intellisense.

 

[Hans810]

Hello Colin,

Thanks for your reply. In my excel Add-In I can see the add-in named ExactGlobe, with the file EG2000.xla. Maybe this helps you for an answer. Regards, Hans

 

[Hans810]

In the mean time I found the answer to my question myself (with the help of some friends.....):

Dim ctlMenuItem As CommandBarControl
Set ctlMenuItem = CommandBars("Exact Globe").Controls(6) 'six buttons in total

"Exact Globe" is the ERP software I am using to extract the data.

Range("A5").Select 'Cel A5 in which the SQL Query is locked in
ctlMenuItem.Execute 'starts the "push" on the refresh button which is on the sixth position in the toolbar

Hope it can be helpful to other VBA users.