Re: How to automate the following tasks?

On Fri, 30 Apr 2010 11:15:23 -0700 (PDT), LunaMoon wrote:

> 1. Open up an Excel 2003 worksheet A;
> 2. Click a button in A, wait for a while, and save it;
> 3. Open up another Excel 2003 worksheet B; must be opened in the same
> process.
> 4. Press F9 to recalculate/refresh this sheet B.
> 5. Save the file B.

Beside other suggestions, you could write the whole thing in Excel VBA and
place the code into Workbook_Open() event handler so it would execute every
time this workbook is opened.

> I need to run this whole procedure every morning at 3am...

Then you would only need to setup a batch file or a VBScript file to open
(execute) that workbook and schedule it through Scheduled tasks to run
every day at 3 am.

--
Pozdrav
===========