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

"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=wo... n.com&rnum=22

or try this search: workbooks saveas csv


"Nilesh Butala" wrote in message
...
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
Thanks for the help. I will try this solution.

Nilesh

"Bob Kilmer" wrote:

"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=wo... n.com&rnum=22

or try this search: workbooks saveas csv


"Nilesh Butala" wrote in message
...
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