Re: Searching for a solution with Batch programming

On Feb 26, 4:44 pm, "Alf P. Steinbach" <al...@xxxxxxxx> wrote:
* Riva...@xxxxxxxxx:



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.

Excel is good at converting Excel worksheets to CSV.

To automate Excel you can use JScript or VBScript.

Cheers, & hth.,

- Alf

--
A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?

Again I was kinda trying to avoid anything excel related as we don't
have a office package on the server, and this is going to be an
automated thing.
.

Quantcast