I need help writing a batch file that will have an excel file run everyday via task schedular. I am using a batch file because I need the file to run everyday, even weekends, when I am not here and don't trust others to actually run the program. I don't know if it CREATES more PROBLEMS but the excel.exe and the file that needs to be run is on a network drive. If anyone has others suggestions for getting the job done, I am more than willing to listen. Thankshttp://www.kayodeok.btinternet.co.uk/favorites/kbofficeexcelhowto.htm#kbhowtoTry the code below (or a version of it). The cd bit should point to where the program excel.exe exists, then in the start line you will need to include the full path of the excel file. When you run the batch file it will open up a new copy of excel and your spreadsheet with in it.

d:
cd "D:\Core\Microsoft Office\Office"
start excel.exe e:\watchdog.xls
exitInstead of DOS, you could run Kirby Footy's Kirby Alarm. This UTILITY will run TASKS that Task Scheduler drops when the machine is off or busy at the intended times, and serves well as a cron utility for Windows. You can run either batch files or Windows shortcut links from the Kirby Alarm scheduler.

Or you can use a DOS-level cron utility...