Edit query macro

T

Tony H

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.
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Need Help with Macro Security 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Macro to select and delete levels of a document 2
edit query macro 0
Creating a Chart on form from selected data in query. 0
cell.address gives strange result 1
VBA word change keys 0

Top