[AccessD] Export data from query to Excel

I can't get anything from the archives right now...

Anyone got a nice routine for exporting data from a query to an excel
spreadsheet?

I have a query that I will change the criteria in to get the specific
results I need.  I then want to run a routine to export that data to a new
worksheet.  The query structure will always be the same - just different
data.

So all I need is a way to export the data while allowing me to create the
worksheet name at the time of the export.  I have to do this about 150 times
so automation would be nice.

Thanks.

Reuben Cummings
GFC, LLC
812.523.1017