When using the below code I open a file with a column of dates in a
"d/mm/yyyy" format eg 1/07/2008.

When I open the file manually the dates are fine however for some unknown
reason when the file opens with the macro dates with a "d" less then 10 are
converted to a date and changes the order of the day and month eg 7/01/2008.

"d" greater than 9 are not regognised as a date and are shown as a text entry.

Does anyone know what is going on??

Workbooks.Open FILENAME:= Range("DEFAULT_FOLDER") & Range

("WORKING_DEFAULT_FILENAME")