What Macro Command To Use to Close Query Results Screen

[unit91]

Am working with Access 2007. I have built a macro that opens several make table queries and exports the tables to excel spreadsheets. Macro functions properly, however the query results still show in the access database screen. What macro command can I use to close these screens after the action is done? I use the CLOSE command for each query but the results still show in the Access window.

[alansidman]

Suggest you post your code so that it can be evaluated and determine what the issue is.

[June7]

Not finding example of macro accomplishing this. Probably need a button on a form to close open query objects or manuall close.

Alternative - don't use macro, use VBA to run the Access query object or execute SQL statements.