automate open/update/close Excel
 

Is there a way to automate opening, updating a query (i.e. hit the
"!"), saving, and exiting Excel?

I would prefer a cmd type script I can schedule to run during off
hours, but I'm open to other suggestions.

I have a spreadsheet we use to track metrics for bug reports. The
spreadsheet was created using an ODBC data base query which can be
easily updated by opening the spreadsheet and updating the query. I
need a way to automate the update on a regular basis. The query takes
10+ minutes so I would like to do it at night instead of having to wait
for the query every time I open it...not to mention I have others who
use it and don't have the ODBC tool set available.

I would guess the solution would be a combination of a cmd script along
with an Excel macro. Can an Excel macro do a file exit (and save)?
Thanks

-rosen