Other Issues - VBScript Excel Scheduled Task |
| Chris Wieman posted at 03-Nov-08 11:08 |
 | I have a Scheduled Task (a CMD file with 2 lines of code (cscript script1.vbs and cscript script2.vbs) running on a W2000 server with MS Office 2003. Both scripts open Excel, execute a query, and format the returned data in a pivot table. If I run the script from the Command prompt, it runs successfully without error. The scheduled task opens Excel, but then does nothing. Excel can be seen in the Task Manager and exits only after the scheduled task timeout (Currently 2 hours).
I can include the script if you need it. |