Is there a way for VBA to execute a "Quit and Use query" exit from Query Design mode for all queries in an existing Excel workbook?
The problem is that I have inserted many queries with different variables (in this case Accounts) into an Excel workbook and then made some changes to the query itself.
I notice that a simple refresh doesn't properly refresh with the latest changes I made in query mode. And I want to avoid manually going to each query and entering design mode - only to Quit and Use query to force an proper refresh.
Thank you very much.