Excel Macro/VBA Program That Converts To CSV

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

Hi

Are all these files single sheet entities, or are they multi-sheet? If so, what do you want to happen to the other sheets given csv files can only be considered as single sheet files? Why do you want to do this out of interest?

Originally Posted by RichardSchollar

Hi

Are all these files single sheet entities, or are they multi-sheet? If so, what do you want to happen to the other sheets given csv files can only be considered as single sheet files? Why do you want to do this out of interest?

Hi, these are single sheet files so i'm hoping the csv conversions shouldn't be a problem.

But if I did want to convert multiple sheet files to csv then is there another solution?

The reason why I want to do this is because I have a large number of files that I want to convert to CSV fairly regularly and instead of doing them one by one I wanted to automate the process so that it is easer in the future aswell.
I guess the whole purpose of doing work is to do as less as possible and still get the work done

wow, it works like a charm. thanks very much. i really appreciate it. It's really really good :D !!!

Just one question though: I noticed that to convert the file, the macro opens the file, saves it as CSV, closes file, and then opens the next file in the directory.

Is there a way to convert the files to CSV without opening them?

Suppose the computer memory was very low then it would be more feasible to convert them without having to open up the XLS first...

any suggestions there please??

Yes: buy more memory.

It opens files one at a time. How much memory to you need?

suppose you are working with many other applications, then it is a problem if you have to open the excel file first.

any suggestions here? thnx.

Nope, no other suggestions.

If that was a requirement, it would have been thoughtful to mention it in your original post.