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.
