Need an Excel Expert plz...
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
