Forum Discussion
Refresh All button, multiple Query Tables, and VBA
I have an Excel workbook containing multiple Query Tables. To refresh the data in all the Query Tables, I want the User to click the Refresh All button on the Ribbon. I have a block of VBA code I w...
[Makro] Bestimmte Power Query Abfrage Aktualisieren
Option Explicit
Sub Makro1()
Dim MyList As ListObject
Set MyList = Worksheets("Tabellenblat_Name").ListObjects("Tabellen_Name")
MyList.QueryTable.Refresh BackgroundQuery:=False
End Sub- NikolinoDE
I am not sure I understand how this subroutine would accomplish the goal. How does this make possible the triggering of my block of code after all tables have finished being refreshed?How to add a custom Ribbon tab using VBA?
I probably misinterpreted the translation, anyway here's some additional info
...if this doesn't help, please ignore my post.
If you allow, would recommend to inform more info about Excel version, operating system, storage medium. A file (without sensitive data) or photos with a more detailed explanation lead to greater success in getting a precise and accurate solution proposal.
