Thank You , worked perfectly! would i be able to use the same macro to convert the csv files to txt, if i change the CSV part in the code?