Running updates reports automatically

Hello,

This might be a bit of a newbie question and I think I need a pointer
in the right direction (unless the answer's an easy one :)

Currently, I've got a number of reports which consist of a number of
Excel worksheets(duh!:). The raw data is retrieved by doing a Data
Import which runs a SQL Query to a SQL server via ODBC. SO, now that I
have the report and graphs like I like them, I just go in once a week
and do a refresh and then send out my worksheets.

Here's my Question. What I'd like to do is just run a scheduled TASK
that goes, runs the refresh on the SQL query and the various
worksheets. (then, ideally, it would also mail the updated worksheet
to a dist. list or upload to Sharepoint)

I've gotten Frye/Freeze/Buckingham's pretty good Microsoft Office Excel
2004 Programming book and skimmed through a few others but all the
programming is resolves around running programs/macros from with-in
Excel.

Any suggestion's/pointers? It would be greatly appreciated.

Kind regards,
Alex

.