Scheduled task hanging

  • Thread starter Thread starter codemind
  • Start date Start date
C

codemind

I have an application developed in VB6 that uses Excel
2002 to convert an Excel sheet to a CSV file.

The app should run unattended via a scheduled task on a
Windows 2000 server. If I run the app manually on the
server it works fine but if I try to run it via the
scheduled task it hangs.

Anyone an idea what this could cause?
 
How does it hang or what does it hang on? Hmmm...bad choice of words....how
about this: How do you launch your Excel file? You should be doing it in this
format:
C:\Program Files\Microsoft Office\Office10\EXCEL.EXE yourExcelFile.xls
where yourExcelFile.xls is the complete path and filename of your Excel file.
What you are doing is providing the path to launch Excel, a space, then the
path to your workbook. The above path to Excel is the default install for
2002 on XP on my system; yours may be different so double-check.
 
Back
Top