Hi- hope someone can help with this - its casuing me big problems.

I have just upgraded to excel (2003), and have an issue with when I am
opening text files in excel, using the opentext VBA command.
If I open the text file manually, I have no problem, all cells with dates in
them are recognised as dates. When I open this file and bring it in using
VBA, it recognises some of the dates as text, and so messes up my
calculations (have to press f2 and return in each cell to get them recognised
as a date).

I'm pretty sure that this is because it tries to bring them in in american
format for some reason, but has a problem when what it sees as the month
goes above 12 and therefore sees it as text (i.e
it brings it in as mm/dd/yyyy - however the file is dd/mm/yyyy do if dd12,
it sees it as mm12 therefore brings it in as text).

Additional info:
- date settings on my computer/excel are fine
- the file is a *.txt not *.csv
- Only happens when I use the VBA command (manual open is fine)

I think this is a bug (tried it on 5 computers)- any help would be
massively appreciated.

thanks in advnce