I'm putting together a spreadsheet that contains multiple ODBC remote data
connections and what I'm trying to do is set up a prompt that refreshes the
data in the spreadsheet properly. The problem is that one of the remote
connections is actually a stored procedure that updates some info on a SQL
server that needs to be run before one of the other queries refreshes.

So my quesion is if there are VB commands to refresh single connections at a
time, so I can make sure they refresh in order.

I tried this code but got an error message:
Range("Data!BH4").Select
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False

The error I get is "Run-time error '1004': Select method of Range class
failed".

I get the same error if I try to replace the "Data!BH$" part with the actual
name of the data range as well.

Just wondering if there's an easier way to do this.