Refreshing imported tables with VBA
Dear,
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!
Subject
Views
Written By
Posted
Refreshing imported tables with VBA
1203
March 29, 2018 02:53AM
765
April 05, 2018 09:52AM
608
June 12, 2018 10:09AM
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.