MySQL Forums
Forum List  »  MySQL for Excel

Re: Refreshing imported tables with VBA
Posted by: Javier Treviño
Date: April 05, 2018 09:52AM

Hi Kevin,
The refreshing of tables imported by MySQL for Excel into Excel workbooks is done through custom code using Visual Studio Tools for Office. Unfortunately VSTO does not expose a hook for Workbook.Refresh or Workbook.RefreshAll that MySQL for Excel can use to call the custom refresh for MySQL tables.

So, the custom refresh code is called when doing a Refresh All using the button in the Office ribbon or using the context menu or using the standard menu. This means the VBA call you mentioned will not do what you need.

There is a plan for a future version of MySQL for Excel to support an API exposed to VBA where people can leverage operations done by MySQL for Excel, which would be useful for people that needs this kind of scripting within Excel.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Refreshing imported tables with VBA
530
April 05, 2018 09:52AM


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.