I am having date formatting problems when saving an Excel file in csv format. The dates in the Excel spreadsheet are originally formatted as dd/mm/yy but after converting to a csv file the dates get changed to mm/dd/yy format.
I can see no way of stopping this happening and worse I am not convinced that this always happens the same on all target machines.
I am using MS Excel 2000.
The conversion is being done by - wkb.SaveAs FileName:="Myfilename.csv", FileFormat:=xlCSV
Does anyone have any ideas as to how I can gain control of the date format that ultimately appears in the csv file?