Inserting a group of queries into a macro

[eerich]

Is it possible to setup a group of queries and then copy the entire group into a macro at once?

Also, once they are inserted, and the 'openquery' action is set, is there a way to set the data mode for all queries to 'readonly' instead of 'edit'?

Thanks.

 

[ZmrAbdulla]

Can you please elaborate what you are trying to do?

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[eerich]

I have 23 queries that I would like to setup to run as a batch through a single macro. I'm hoping there is a method whereby I can just create a group in the query view and include all the queries, then attach that group to a macro and have it execute and export the results to Excel files. Once exported, I have a utility that can load all of the individual excel files into one workbook.

As for the data mode, I need to make sure the openquery is set to 'readonly' vs. edit, because in 'edit' mode, it seems the queries are executed then deleted.

 

[ZmrAbdulla]

You can do it with "OutputTo Method" in vba

Private Sub cmdOutput_Click()
    DoCmd.OutputTo acOutputQuery, "MyQuery1", acFormatXLS, "C:\MyQuery1.xls"
    DoCmd.OutputTo acOutputQuery, "MyQuery2", acFormatXLS, "C:\MyQuery2.xls"
    DoCmd.OutputTo acOutputQuery, "MyQuery3", acFormatXLS, "C:\MyQuery3.xls"
End Sub

It will just create excel files..

See more in the help file

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.