Run a MS Excel 2010 addin toolbar command through VBA

Hello all,

I have an excel file which is connected to an external database application through an ADDIN (Microsoft SQL server 2012; Master Data Services)

This Addin has a refresh button, which basically re-establishes the link between the excel file and the Database and updates the sheet, dumping the Database Table into the excel file.

I can then update the excel sheet directly and then publish the data, which will in turn update the database.

I have built up VBA code to update the sheet which is linked to the database, but I need to make sure that this sheet is up-to-date (i.e. according to the current version in the database) before updating it and then publishing the changes.

I.e. I would need basically to find a way to run through VBA the command that is currently executed when I click on the refresh button of the Addin toolbar.

Does anyone have a solution for this?

Thanks
TT