MySQL Forums
Forum List  »  MySQL for Excel

Refresh a table in excel with VBA
Posted by: Paul Keddie
Date: December 04, 2017 05:33AM

Hi there.

I have loaded a table into Excel from an on-line MySQL DB and I need to refresh it programatically (as the tables will be on hidden sheets for the end user).

There is no problem refreshing it with 'right-click' & 'refresh' in the table but when I try to refresh it with

ThisWorkbook.RefreshAll

it doesn't refresh.

Any ideas?

Thanks in advance

Paul Ked

Options: ReplyQuote


Subject
Views
Written By
Posted
Refresh a table in excel with VBA
36
December 04, 2017 05:33AM


Sorry, only registered users may post in this forum.

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.