Excel 2016 - Web Query won't refresh before rest of code runs?

[nobodyukno]

I have searched this issue before and have tried other solutions to no avail. I have a Web Query connection to bring in a table from a website. My macro intends to refresh this connection, and then append this information to another tab to create a historical list of information.

If I go to the Data Connection properties it says my connection type is "OLE DB Query." The command type is SQL.

I made sure to uncheck "Enable Background Refresh" on the table as well.

From all those adjustments, it seems like my code should run, but it does not. The code runs and finishes before the query refreshes. Here is my code with some of those attempted adjustments:

Please Login or Register  to view this content.

I have also attempted wait or delay functions, but they just do the wait or delay and then once the time is up, then the workbook tries to refresh the connection and the code still finishes before the query refreshes.

[Olly]

Try something like this, to force a "foreground" refresh:

Please Login or Register  to view this content.

(oh, and please update your profile to accurately reflect your Excel version!)

[nobodyukno]

Try something like this, to force a "foreground" refresh:

Please Login or Register  to view this content.

(oh, and please update your profile to accurately reflect your Excel version!)

Nailed it!

Thanks for the help!