VBA not cycling through and processing all files in folder

Hi all,

I've been working on some code with the help of a fellow board member to cycle through csv files in a folder and modify the date format from DD/MM/YYYY to YYYY-MM-DD, save each exit and move onto the next.

In my original code the macro would cycle through the files sucessfully and display a message telling the user how many files were processed, but upon opening the csv files in wordpad some of the dates would have switched from YYYYY-MM-DD to YYYY-DD-MM, generally these were where the MM-DD were both under 12, i.e. the month was < December.

This code is below:

Please Login or Register  to view this content.

The improved code provided by Philb1 sucessfully changed the dates in the first csv file processed but doesn't cycle through the remainder of the files in the folder, or display a message telling the user how many files have been processed.

The code is:

Please Login or Register  to view this content.

Would anyone know what's wrong with the code above and why it's stopped cycling through the files?

I've attached the vba in a workbook for anyone if that's easier.

Regards

David

Hi Rory, that seem to work very well.

Can I ask how you managed to get the format to stay as YYYY-MM-DD even for the lines where the DD-MM could be transposed? In all of my attempts I'd get 2014-04-06 when it should have been 2014-06-04, and the formula "=TEXT(RC[-2],""YYYY-MM-DD"")" looks identical to my original one.

Regardless that's a fantastic result and much appreciated.

Cheers

David

Hi Rory, that seem to work very well.

Can I ask how you managed to get the format to stay as YYYY-MM-DD even for the lines where the DD-MM could be transposed? In all of my attempts I'd get 2014-04-06 when it should have been 2014-06-04, and the formula "=TEXT(RC[-2],""YYYY-MM-DD"")" looks identical to my original one.

Regardless that's a fantastic result and much appreciated.

Cheers

David