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


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
16 views
Recently got a very useful addition to Excel, which in real time receives data from the servers and writes to Excel.
However, to refresh the data click on the Refresh button (Main menu-Tab add-on).
You can write a macro that will every 1-2 minutes to click on this button.

Google only answers how to attach a macro to the button, but it's generally not.
by | 16 views

2 Answers

0 like 0 dislike
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.
by
0 like 0 dislike
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
by

Related questions

0 like 0 dislike
3 answers
0 like 0 dislike
1 answer
asked Jun 14, 2019 by Rphoenix
0 like 0 dislike
1 answer
asked Apr 25, 2019 by kapitoly
0 like 0 dislike
3 answers
0 like 0 dislike
1 answer
110,608 questions
257,187 answers
0 comments
40,796 users