Edit query macro

[Guest]

I have a query that includes a field called "state". I need a macro that will
open the query, change the state to each state in the query, and then export
each state specific query to an excel file. I've figured out the export
function, but cannot figure out the edit query function.

 

[Ken Snell [MVP]]

Cannot be done by a macro directly. You'd either need to set up separate
queries (one for each state) and export each query, or use VBA code to
modify a stored query as you desire before you export it each time.