VB Script to automate Excel does not run as Sheduled Task
 

Hi All,
I have a VB Script that does some excel automation. Basically it parses a
text file and builds a spreadsheet from the data within.
The OS is Win2K Server.
The script runs fine if run 'manually' but always hangs if run as a Sheduled
Task.

Has anyone else seen this problem? I should mention that *any* script that
automates Excel will not run as a Scheduled Task.

--
Dan Artuso

VB Script to automate Excel does not run as Sheduled Task
 

Do scripts that don't have anything to do with Excel run?

How do you launch the script manually? How do you launch as a scheduled
task?

If your script is named myscript.vbs, try scheduling
wscript.exe myscript.vbs
if that isn't the way you're doing things now. You may need to have the
complete path to wscript.exe but probably not.

Steve


"dan artuso" wrote in message
...
Hi All,
I have a VB Script that does some excel automation. Basically it parses a
text file and builds a spreadsheet from the data within.
The OS is Win2K Server.
The script runs fine if run 'manually' but always hangs if run as a
Sheduled Task.

Has anyone else seen this problem? I should mention that *any* script that
automates Excel will not run as a Scheduled Task.

--
Dan Artuso

VB Script to automate Excel does not run as Sheduled Task
 

Hi,
Manual means double clicking the vbs file.
For a scheduled Task, we simply schedule it and wait for ir to run.
The task does start and we can see the instance of excel in memory, it just
hangs though.


Dan Artuso


"Steve Yandl" wrote in message
...
Do scripts that don't have anything to do with Excel run?

How do you launch the script manually? How do you launch as a scheduled
task?

If your script is named myscript.vbs, try scheduling
wscript.exe myscript.vbs
if that isn't the way you're doing things now. You may need to have the
complete path to wscript.exe but probably not.

Steve


"dan artuso" wrote in message
...
Hi All,
I have a VB Script that does some excel automation. Basically it parses a
text file and builds a spreadsheet from the data within.
The OS is Win2K Server.
The script runs fine if run 'manually' but always hangs if run as a
Sheduled Task.

Has anyone else seen this problem? I should mention that *any* script
that automates Excel will not run as a Scheduled Task.

--
Dan Artuso