I'm using Excel VBA to run a SQL query, put the results in a seperate worksheet and then after that run a find and replace on a specific column.

If I run this through the find and replace doesn't happen. However if I put a break point on the coding and F8 through the find and replace works.
it's as if the F&R is working before the SQL query has finished. I've put wait commands in and that's not solved it.

I hope somebody could help me on this please.

Thanks

Make sure your BackgroundQuery is set to False



With ActiveSheet.QueryTables.Add( _
        Connection:=sConn, _
        Destination:=ResultLocation, _
        Sql:=sSql)

        .RefreshStyle = xlOverwriteCells 'Over-write the existing data from previous queries
        .AdjustColumnWidth = False 'Prevents the query from adjusting the column width every time it runs
        .RefreshOnFileOpen = False 'Shutsdown the automatic refresh function
        '.FieldNames = False 'Hides the column headers that come from the query
        .Refresh BackgroundQuery:=False 'Actually sends this query, the background false options prevents the program from continuing until the refresh is complete

End With

Perfect!! - thank you very much