Hi,
Can someone please help me with a date formatting problem.

When I save a sheet to a TXT file manually (using the SaveAs option, etc.),
I have no problems and the dates remain as they are shown on the sheet as
d/m/yy (eg 15/9/05), but when I use the following macro, the dates on that
sheet are saved to the text file as month/day/year (eg 9/15/05)

Sub ExportToMYOB()
ActiveWorkbook.Save
Sheet2.SaveAs Filename:="C:\Premier9\Data files\ExportToMYOB.txt", _
FileFormat:=xlText, CreateBackup:=False
ActiveWindow.Close
End Sub

Why is it so?

Rob