Need an Excel Expert plz...

[Devil Man]

Hey,

I have this really annoying task to do at work that I think could be made easier with a batch conversion utility.

Here's the gist of the problem--->

I have to convert about 5000 .xls files to .csv files (comma delimited). The only way I know of so far it to open the file in excel, then go to Save As, then overwrite the file by choosing the *.csv in the Save As Type drop down menu.

Not surprisingly, this is very time consuming so does anyone know if I could batch convert the files with some free utility? (Tried searching with google but I could only find "xls2csv" for Linux and BEOS, NOT Windows NT).

Of course if someone knows any VB code that'll do this that'd be cool to.

Thanks for any help...

------------------
Athlon 1.2 GHz with 266 fsb
Gigabyte 7DX
256 PC2100 DDR RAM
ATI RADEON 64 Meg DDR VIVO
SB LIVE 5.1
SMC 10/100 Network Card
Pioneer 16x DVD + Plextor 8x CDR
Surfboard 3100 Cable Modem
Videologic Digitheatre
Mitsubishi 19" NF
Antec SX830
http://gamershq.madonion.com/compare2k1.shtml?1182955

[kid A]

Well I'm no Excel expert but I found this link just searching for "XLS to CSV converter" on Google:
http://www.softinterface.com/WCX/WCX.htm


Can you use any of that code that you see some way down the page?

------------------
Now listening to:
Sex Pistols - Never Mind the Bollocks...

[sscleaner]

You can try by programming on VBA. There are such fuctions like Open and SaveAs.

------------------
Celeron 633@902 (FSB=94 Mhz)
Abit BF6
256 Mb PC133 Cas 3, 64 Mb PC100 Cas3
Asus v8200 Deluxe GeForce 3
det. 21.81 from Nvidia
Nec MultySync 75F Monitor
IBM 60 GXP 40 Gb
DVD Sony 16/40
Yamaha CRW 2100 E 16/10/40
SB 64PCI