Hi all,
I have something odd happening when trying to open a sheet via a VBA macro.

I download a file from a midrange system as a DIFF file format to import into MS Excel 2003via a simple VBA Macro.

Now when I open that sheet manually, there is a date column which is formatted as ddmmyyyy and it displays correctly. This is the date format I need.

When my macro opens that same sheet, then the date gets reversed as mmddyyyy.

The vba code I am using (and copying in here freehand) is very straight forward:
Sub LoadData()
Dim ipname
ipname = "I12dailyCPT.xls"
Workbooks.Open FileName:=
   "C:\Documents and Settings\Itsme\Desktop\" & ipname"
End Sub
As I say when I look at the sheet that when opened by the macro that date is changed around. The first thing I do after loading the sheet is to validate the date so I'm kinda stuck

I need to understand why this is happening before I can even think about how to fix it or work around it.

Greatly appreciate any help.