Hi, do you know if VBA in excel can create a macro or some kind of program that will take all the .XLS files in a particular folder and then create them all into .CSV format, IN ONE GO?

So suppose I have a directory:
C:\EXCEL_FILES

Let's say the folder EXCEL_FILES has 4 files:
- file_1.xls
- apple2.xls
- olympics.xls
- financeoption.xls

as you can see these files have no particular ordering to them as their file names are completely different.

So would excel be able to simply just choose the folder (EXCEL_FILES) and then convert all those 4 files into .CSV format at the click of ONE button?

I want the program to process all files in one go..

Any ideas please guys?
Your help would be very much appreciated.

Many Thanks