Workbook Open after automatic refresh

I have some code that finds and replaces text in some columns in different worksheets on opening the workbook.

My problem is that have some web queries that want refreshing on opening the file and this refresh happens after replacing the text. I want the refresh to happen before finding and replacing the text.

Thanks,
Adam.

I'm new to VBA and don't know if this is possible.

When you save the workbook, can you programmatically 'comment' out the web queries and have your workbook_open procedure 'uncomment' them AFTER the find & replace has run?

I'm sorry if my original post was not fully clear (i was in a bit of a rush when posting), so i have attached my workbook as an example.

Hopefully someone can help. Any questions please ask.

Thanks.

ok, sounds like the most simple solution but if i take the automatic refrsh off the queriea on opening the file how do i code the workbook open procedure to refresh the web queries before running the rest o the procedure.

Thanks,
Adam.

Thanks, that works great. I have also some more code now to the open workbook procedure which removes the text i want removing and autofits the columns in each the worksheets in the workbook.

This works fine but i think the way i've written the code for this part must be a long winded way. Is there a neater way of writing this part so it goes through each worksheet in the workbook? Similar to how the beginning of the code goes through each worksheet and refreshes the query tables.

Please see this latest example.

Thanks.