Skip to Content
0
Former Member
Aug 11, 2005 at 03:13 PM

Bex query re-embed from VBA

29 Views

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.

KK