VBA code to convert .csv to .txt

[CamBF]

Hi guys,

Need urgent help please. We require a VBA code that can be assigned to a macro button that does the following:

1. When pressed brings up a dialog window to select a folder containing all .csv files
2. Code goes through entire folder and converts all .csv files to .txt files
3. Code creates a folder in .csv file location named ".csv files" and moves all .csv files into this folder

Thanks

 

[CamBF]

Hi,

Also need to have the code search each .csv file as it converts it to a .txt file and replace all ";" within the .csv files to ",".

Thanks