atermeer
09-04-2007, 02:29 AM
I will try this question again. I have a workbook and a few needs:
I have a workbook that I want to open every day at 8:30 AM.
When it opens, it needs to update from its external data source (this concerns me; as it stands now when you open it you must select the option to allow it to automatically update).
Once updated, I need it to print.
Then I need it to save with filename and yesterday's date (I think I have this part figured out). (No specified path means in same folder as when opened, right?)
Then I need it to close.
That is all I need. Some background:
The computer is a network computer which is on 24-7. I have understood to open a workbook using scheduler, but I can only see how to open Excel, not a specific workbook. I appreciate any and all help...
I have a workbook that I want to open every day at 8:30 AM.
When it opens, it needs to update from its external data source (this concerns me; as it stands now when you open it you must select the option to allow it to automatically update).
Once updated, I need it to print.
Then I need it to save with filename and yesterday's date (I think I have this part figured out). (No specified path means in same folder as when opened, right?)
Then I need it to close.
That is all I need. Some background:
The computer is a network computer which is on 24-7. I have understood to open a workbook using scheduler, but I can only see how to open Excel, not a specific workbook. I appreciate any and all help...