View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Toby Erkson[_2_] Toby Erkson[_2_] is offline
external usenet poster
 
Location: Portland, Oregon
Posts: 26
Default Scheduled task hanging

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?