Close a query after run

[Elamranii]

Hi,
I have a Macro that run 8 Make Table Queries. Once the macro is done it leaves all 8 queries open. How do I make Macro close all queries when completed?
Thanks in advance
Ismail

 

[PHV]

A real make table query shouldn't stay open ...

 

[Elamranii]

Sorry they're all Select queries.

 

[PHV]

So, why launching queries if you want to close them ?

 

[Elamranii]

what I am trying to do is export this queries to an excel sheet. Once the export is done they all stay open.

 

[PHV]

Have a look at the OutputTo and TransferSpreadsheet methods of the DoCmd object.
No need to open the query to export it.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Elamranii]

I worked. Thanks for you help and your patience.
Ismail