MySQL Forums
Forum List  »  MySQL for Excel

Refreshing imported tables with VBA
Posted by: Kevin Bourdeaux
Date: March 29, 2018 02:53AM

Mysql for Excel is working great to import my database tables into Excel.
There is a feature to refresh the data every X minutes, but as I need a refresh every 5 seconds, I'm trying to use VBA to achieve this.
When clicking on the Refresh All button, the data is refreshed. However, when doing a 'Thisworkbook.refreshall' or any other command refreshing the table in VBA, nothing happens.
Could it be that Mysql for Excel disabled data refresh commands when coming from VBA?

Thank you for your help!

Options: ReplyQuote

Written By
Refreshing imported tables with VBA
March 29, 2018 02:53AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.