Hello,

I m trying to copy and paste a worksheet from a workbook to another
worksheet of another workbook but the dates seem to change instead of
d/mm/yyyy they go as mm/d/yyyy. I m using
Workbooks("hello.csv").Sheets(1).Copy _
Befo=Workbooks("uks_payslip.xls").Sheets(1)

Can anybody help please?

Thank you