Convert multiple txt files in folder to csv

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

Thanks than_gold for your help, I have got a runtime error at....

Set targetF = oFSO.GetFolder(oFolder)

Any ideas?

Here you go!

runetime424.jpg

debug.jpg

I have set this to true but unfortunately the same error comes up

Dim oFSO should be dimmed as object. The same for all variables as assigned using "Set"

Dim oFSO as object

It is going to be the same issue with all variables not dimmed as obejcts: Ftarget and etc.
You will get an error if you tell VBA you are assigning an object by using Set and then variables are declared as "Variant"

If they are comma delimited text files...

Sub test()
    Dim myDir As String, fn As String
    With Application.FileDialog(msoFileDialogFolderPicker)
        If .Show Then myDir = .SelectedItems(1) & "\"
    End With
    If myDir = "" Then Exit Sub
    fn = Dir(myDir & "*.txt")
    Do While fn <> ""
        Name myDir & fn As myDir & Replace(fn, ".txt", ".csv")
        fn = Dir
    Loop
End Sub

That works!!!!

I am going to test it but it seems to work perfectly.

Thanks so much for your help

You are welcome and don't forget that all the text files in the folder must be comma delimited.
The code will rename the extension regardless of the delimiter.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Yes, all the files will always be comma delimited.

I will mark this as solved now, thanks again.