Running updates reports automatically

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

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
 
Excel has the application.ontime function, but this is largely for
scheduling things inside excel when it is open. You would need to put your
code in the workbook open event of a workbook and then use windows schedular
to start excel with your workbook as an argument. This should kick off you
macro. You can see Ron de Bruin's site for information on mailing

http://www.rondebruin.nl/sendmail.htm
 
Back
Top