Recorded macro TexttoColumn doesn't works

[danusko]

Hi,
i started to use Excel 2016 and i met with this strange behavior of Excel. I use Excel in Slovak (EU) region.

I try to convert date format value (DD.MM.YY hh:mm:ss) loaded from txt file with text to column functionality but it doesnt worked.

When i do it manualy, it works like a charm, but when i record the macro and then try to run it, its only select range and doesnt convert the dates.

Pls. any suggestions?
I also tried do it with function multiple (copy and special paste), and the result was the same. I mean, i wrote 1 in blank cell, then i copy this 1 and tried to apply it to selected cells with txt date. When i did manualy it worked, but macro did not.

I also tried with turned off my personal.xls file with blank excel but its also not worked.

this is the simple macro with txtto column recorded function wich didnt worked.

Sub Makro5()

    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
End Sub