my macro changes the date format why?

i recorded a macro to copy data form one workbook to another when i do this procedure by hand there is no problem. but when i used the recorded macro it changes the format of the date from "general" to "date" but the date format it chooses is the wrong (U.S)

I dont need it to do anything to the data when it is copied but it does!!! why ??


please help its really irritating!


Thanks for all the help


the code of woe!

Windows("weekly report template.xls").Activate
    Sheets("export").Select
Sheets.Add.Name = "export"
Workbooks.Open Filename:=ThisWorkbook.Path & Application.PathSeparator & "export.csv"
    Cells.Select
    Selection.Copy

Windows("weekly report template.xls").Activate
    Sheets("export").Select

Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False


Windows("export.csv").Activate
Application.CutCopyMode = False
ActiveWindow.Close

Sheets("functions").Select
End Sub

Can you read the Forum Rules & start using Code tags if you want help. Thanks