Hi Friends,

I have recently been troubled with a problem of converting comma delimited csv files to xlsx format excel files. I dont, know a code to make it automatic, neither a macro, so I open the individual file and do "save as .xlsx", which doesn't seem practical anymore with dozens to convert each day.

It's a bit confusing as well because when I open the individual CSV file it opens in excel and i save it as xlsx, but when I used some simple macros it didn't work that way, the macro took it as a text (txt) file! Why is that so wonder?

Could you suggest me how to make this process automatic, using a macro? It could be easier to hardcode the files location or let the macro ask me the folder location to run the process.

Thanks alot in advance for your generous replies and solutions.
Sanjeev