Format date change from US/Europe while exporting to excel using macro

[Safa_Guedria]

Hello,

We use a macro to export a table in Excel.

the table contains dates, when we open the file with Excel in US version the dates are correct, in the right format DD/MM/YYYY but when we open it in Frensh version, the dates with day < 13 are changed to MM/DD/YYYY (wrong!).

I found in the internet that the month/day inversion of a date is a recurring problem in VBA but I can't find a solution (Défaut de date US / FR dans un macro (excel-pratique.com) ).

I tried to putting Date(field, "DD/MM/YYYY") on script and also on table properties but no success at all.

Could you please help me to solve this issue?

Thank you in advance.

[Safa_Guedria]

@Frank_S  @Gysbert_Wassenaar 

could you please help me to solve this issue?