Absent suggestions on how to increase the OLE DB timeout for SalesForce objects, here's a way to cycle through each query, waiting for each to complete, and get feedback that the query was successful: 'Query names are listed on worksheet(WS) For i = 2 To lastrow strQ = "Query - " & WS.Range("A" & i).Text ThisWorkbook.Connections(strQ).Refresh 'Wait until SalesForce Query has completed before moving to next step Application.CalculateUntilAsyncQueriesDone 'Record results by counting OLEDB Errors (0 is successful update) Debug.Print strQ & ": " & Application.OLEDBErrors.Count Next i
