Re: Refreshing imported tables with VBA

[Javier Treviño]

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