Welcome to the forum.

I don't have Win7, but in XP, you'd schedule the workbook in Control Panel > Scheduled Tasks, and kick off the macro in the Workbook_Open event.