Data Connection Refresh in VBA

BobDonut

New Member
Joined
Jan 19, 2006
Messages
6
I have a spreadsheet that uses Excel's data connection to pull info from various URLs.

There is some VBA code that loops a process, in order to cycle through all the URLs I need to use.

The problem is that sometimes Excel pulls in the same data two or three times in a row. My first suspicion is that the VBA was continuing on to the next part of the code before waiting for the query to finish. So I added this line of code, just before the refresh:
VBA Code:
WB.Connections("Query - CorrelationDownload").BackgroundQuery = False

I'm still seeing results where it pulls the same data for two or three steps in a row, before going back to pulling one data set per step. I can't find any consistency in the error. Sometimes it works for 10 iterations, sometimes 20, etc.

Any ideas on what to try next?
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Watch MrExcel Video

Forum statistics

Threads
1,127,994
Messages
5,628,021
Members
416,287
Latest member
wanji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top