I am looking for a vbs solution to read multiple csv files and extract data from the individual files. Take this data and rename the csv file. So that it loop through all the files in a folder.

Any ideas?