How to use a macro to click buttons in the main menu (Excel)?

Question

Visual Basic

Recently, a very useful add-on for Excel came into my hands, which receives real-time data from the server and writes it to Excel.
However, to update the data, you need to click on the Refresh button (Main menu-Add-on tab).
You can write a macro that will click on this button every 1-2 minutes.
Google only answers how to bind a macro to a button, but that's not it at all.

Answer 1

In total, the add-on was written in c#.
As the Devil said :
The standard ways to update the cell also do not work (by pressing the button, the data is simply unloaded)
.

Answer 2

There is no need to click on the button, it is enough to call the update function itself, because when you click it, the meaning is the same.
About an example of a timer in Excel VBA read Create every second update