Convert *.Xls to *.csv

[Guest]

Hi
I have 2000 old *.xls file which need to be uploaded to AS400. I took care
of the 400 side to receieve the files from NT server as *.csv. Is there a way
to convert *.xls in to *.csv in a batch?

Thanks

 

[Bob Kilmer]

"Nilesh Butala" wrote:
Is there a way to convert *.xls in to *.csv in a batch?

Yes. You'll need to loop thru the files in one or more directories, open
each workbook, loop thru the worksheets or find the sheet of interest (if
more than one) and saveas CSV. I am sure a few google searches will turn up
something.

For instance,
http://groups.google.com/groups?q=w..._qdr=y&[email protected]&rnum=22

or try this search: workbooks saveas csv

 

[Guest]

Bob
Thanks for the help. I will try this solution.

Nilesh