I found a great bit of code from another user to import multiple csv files to one data sheet. However it is messing up the dates in some of the fields.
Data is formatted in the csv as "dd/mm/yyyy hh:mm", however the macro is changing any fields where dd <= 12 to the format mm/dd/yyyy.
Dates above 13th of each month format fine, it's just the first 12 that it's messing up. I would go through and manually import each sheet, but it's 1095 separate csv files!!
Code i'm using is below. Any help is much appreciated.
Bookmarks