MySQL Forums
Forum List  »  MySQL for Excel

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Refresh a table in excel with VBA
1371
Paul Keddie
December 04, 2017 05:33AM
Re: Refresh a table in excel with VBA
1021
Javier Treviño
January 09, 2018 07:17PM
Re: Refresh a table in excel with VBA
860
Paul Keddie
January 09, 2018 07:30PM


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.