Microsoft excel/batch files

danzasmack · #1 08-17-2005, 10:24 AM

At work i have an overnight process that is scheduled to run at 1am. Here are the restrictions:

1) the computer must be on with an instance of excel already open. If it is not open, excel will open when the batch runs, and request a user name/password for a certain addin (morganmarkets RDI for any/all familiar)

2) it must run in excel

every now and then, it just doesnt run. the code (it is VBA, in a macro) is fine, 100% no problem. anyone know how i can fix this or what it might be?

PLOlover · #2 08-17-2005, 11:54 AM

Computer goes into standby?

danzasmack · #3 08-17-2005, 11:55 AM

no, i wish. nothing like that at all.

anyone have any links for VBScript for the Scheduler on newest windows?