Scheduled task hanging

[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?

 

[Toby Erkson]

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.

 

[codemind]

I'm starting Excel via a VB app with the createobject
method.

 

[Toby Erkson]

Hmm, sorry, I don't have a solution :-(
--
Toby Erkson
Oregon, USA

I'm starting Excel via a VB app with the createobject
method.

....