Batch conversion macro to convert xls to csv

[richardcarter]

I have created a macro that performs some data cleansing on a .xls file and saves it as a .csv file.

The problem I have is that there are 1,500 .xls files to perform this operation on.

Is there any VBA code that would just simply instruct the macro to "perform this macro on all the .xls files in xxx folder and when it comes to saving them as .csv, use the same filename as the original .xls but save it as a .csv in xxx folder"

Woudl welcome any other suggestions to get round this...

Hope someone can help! Thanks.

 

[Andrew Poulsom]

This shows you how to loop around all the xls files in a folder:

http://www.rondebruin.nl/mergetotxt.htm