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.

--
Toby Erkson
Oregon, USA

"codemind" wrote in message
...
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?

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

-----Original Message-----
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.

--
Toby Erkson
Oregon, USA

"codemind" wrote
in message
...
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?


.

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

"codemind" wrote in message
...
I'm starting Excel via a VB app with the createobject
method.
....