Searching for a solution with Batch programming



I was tasked with a job to write a batch program to download a excel
file from a FTP and convert it to CSV, getting the file was a 2 second
job. But finding a free program to convert xls 2 csv or txt was a
nightmare. I finally found a standalone app, which i can run from
command line. My problem being after it converts a dialog pops up
saying "Conversion Complete", and I can't figure out how I would go
about exiting the program. The last few lines of commands go:

ftp -s:download.bat
open ftphyperlink
username
password
get test.xls
bye
xls2csv.exe test.xls
exit

Anyone have any suggestions or better solutions? This will be running
on windows server 2003, with no office applications on it.
.



Relevant Pages

  • Re: Searching for a solution with Batch programming
    ... file from a FTP and convert it to CSV, getting the file was a 2 second ... But finding a free program to convert xls 2 csv or txt was a ... Excel is good at converting Excel worksheets to CSV. ...
    (comp.programming)
  • Re: Network Deployment of SP2
    ... MBSA has a command line mode, and you can output scan results into a CSV or ... other file that can then be read into Excel. ... Richard G. Harper rgharper@xxxxxxxxx ...
    (microsoft.public.windowsxp.network_web)
  • Re: Searching for a solution with Batch programming
    ... file from a FTP and convert it to CSV, getting the file was a 2 second ... But finding a free program to convert xls 2 csv or txt was a ... command line. ...
    (comp.programming)
  • Re: Word from command prompt?
    ... Word doesn't have an export filter to CSV the way Excel does. ... I want a comma between each table cell in the CSV file. ... run a macro or a built-in command that doesn't need any further information ...
    (microsoft.public.word.docmanagement)
  • Re: Searching for a solution with Batch programming
    ... file from a FTP and convert it to CSV, getting the file was a 2 second ... But finding a free program to convert xls 2 csv or txt was a ... command line. ...
    (comp.programming)