Hi

I wonder if someone might be able to help.

I am trying to find out if it is possible to batch/bulk convert a high volume of comma delimited txt files into individual csv (comma delimited) files and retain the original filename for each and save them in the same folder. I basically want a script to carry out the same 'text to column' feature within Excel and then save the file with the same filename and it doesn't' matter whether there is one file in the folder or 100, it will loop until there are no more txt files to convert.

Each file row and column length will be variable, the constant will be that they are always comma delimited.

I have been searching through this forum and can kind similar vb scripts but these don't convert all files within a folder and I cannot find anything that will really help, but am sorry if there is something similar that I haven't found yet.

Many thanks