Windows Start, Programs, Accessories, System Tools, Scheduled Tasks.

Use the Workbook_Open event for the workbooks you specify to be loaded.  In
that event, call the code that needs to run to do the tasks.