Copy+Paste macro dd/mm/yyyy to dd/mm/yyyy and NOT dd/mm/yyyy to mm/dd/yyyy

I have dates(dd/mm/yyyy) going across A4 to GA4 in a table in a .xlsm workbook. This table feeds a pivot chart and pivot table on another sheet.

Now I have a macro that opens a .csv file from another directory and selects data to paste in on the table. this data has (dd/mm/yyyy) going across A4 to GA4.

But when I paste the data in the dates are pasted in as mm/dd/yyyy.

Now I have tried stuff like this

    Workbooks.Open Filename:="Filname", local:=True

But I cannot get it to paste the dates as dd/mm/yyyy


Any ideas??