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

Total additions were written in c#.
As said Daway :

Using the macro in any way. The macro runs in the scope of the book and presses the buttons that were added in this book.

Standard methods updating of the cell is also not working ( by pressing the button the data just unloaded)

The solution was to sort out the code dopoleniya and a bit to change it for themselves.

No need to press the button, simply call the function itself updates, because when you press the meaning is the same.
About the example of a timer in Excel VBA to read to Create every second update