vba copying dates from csv file

[grimston]

Hi
Can anyone help me with my code , I am copying data from a csv file and pasting it into an existing workbook, However the date column which should be dd/MM/yyyy some of them switch day and month.
I have attached an example highlighted in yellow in the date column. Here is my coding below Many thanks

Sheets("MENU").Select
Workbooks.Open Filename:="G:\Catalyst\CAT_D_monthlyfundperformanceMTD_" & Format(Range("c4"), "yyyymmdd") & ".csv"
Range("a2").Select
Range(ActiveCell, ActiveCell.End(xlDown).End(xlToRight)).Select
    Application.DisplayAlerts = False
    Selection.Copy
    ActiveWorkbook.Close
    Application.DisplayAlerts = True
    Sheets("Maitland Daily Performance").Activate
    Range("B2").PasteSpecial
    Columns("D:D").Select
    Selection.TextToColumns Destination:=Range("D1"), DataType:=xlDelimited, _
        TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
        Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
        :=Array(1, 4), TrailingMinusNumbers:=True
    Sheets("MAP").Select