Hi i am using the following code to save file as csv, but when i open the file the date format changes from dd/mm/yyyy to m/dd/yyyy, how can i overcome this?
Sheets("Sheet1").copy<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
activeworkbook.SaveAs Filename:= _<o></o>
"s:\Testing\mytest.csv", FileFormat:=xlCSV, _<o></o>
CreateBackup:=False<o></o>
Sheets("Sheet1").copy<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
activeworkbook.SaveAs Filename:= _<o></o>
"s:\Testing\mytest.csv", FileFormat:=xlCSV, _<o></o>
CreateBackup:=False<o></o>