Date Layout (mm/dd/yyyy)

I need to import some csv files but I can not properly manage one of the field because it is a date and that field behave in a way that I can not definitely control;

I got an inversion of month with day so that the final layout is mm/dd/yyyy instead of the correct date layout dd/mm/yyyy I want (need);

the main problem is that when I'm importing these files via a VBA macro like
Workbooks.Open Filename:="n42s3.csv"

the inversion does happen whilst when I'm going through the "normal way" of the menu File, Open... it does not;

and moreover even if I put some commands on the vba macro like
Selection.NumberFormat = "dd/mm/yy hh.mm;@"

in order to control the correct date layout I want I get no result at all

it's a big problem for myself because I need to open a large number of files which can not conveniently handled with the normal way (i.e. passing through the menu)