Hi Brad,

[VBA]
strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
Set objNewJob = objWMIService.Get("Win32_ScheduledJob")errJobCreated = objNewJob.Create _
("Excel.exe", "********040000.000000-420", _
True , 1 OR 4 OR 16, , , JobID)
Wscript.Echo errJobCreated
[/VBA]

This script will run excel every monday, wednesday and friday at 04:00, then you can set at workbook_open to do what you want and close the file.

I hope this helps!

P.S.: This will work on:
Windows Server 2003: Yes
Windows XP: Yes
Windows 2000: Yes
Windows NT 4.0: Yes, with WMI installed
Windows 98: Yes, with WMI installed