Macro incorrectly formatting dates from .csv file

[mikel987]

Hi everyone,

I am processing .csv files using Excel macros. I have a date column with dates in dd/mm/yyyy format. Something odd is happening to the dates when the macro opens the .csv file:

1. When I manually open the .csv files in Excel the dates are formatted correctly, in dd/mm/yyyy format (ManualExcelOpen_Correct.jpg)
2. When the macro opens the .csv file any dates where the dd part is <=12 the date is changed to mm/dd/yyyy (MacroExcelOpen_Incorrect.jpg).

I am using Excel 2016 on a Windows 10 machine.

Any help on this would be much appreciated.

Thank you in advance.

Mike L.