Record another macro when you do it next time.

You shortened up that workbooks.opentext line. It has a FieldInfo:= parm that
contains your spec for how to treat the data. Make sure you pick the correct
format: mdy or dmy (I couldn't tell from your example.).

And if the filename is .csv, rename it to .txt. (VBA pretty much ignores any
choices you've made for importing the values (via code).)



Rodolfo Silva wrote:

I use Windows 2000 (5.00.2195) and Office 2000.
I use a macro that open a text file delimited with
semicolon.
I use the next instruction:

Workbooks.OpenText FileName:=xarchi,
DataType:=xlDelimited, semicolon:=True, Tab:=False

"xarchi" contains the name of the file that I open.

Problem: The macro open the file and changes the format
of dates, i.e. 07/02/2003 when the text file contains
02/07/2003

When I open the file manually (via menu) dates are not
changed.
The macro works fine in Win95, Win98, WinXP and all the
previous Excel versions..
The problem is not at Regional Configuration.
If I use a text file delimited with comma, the macro
opens the file and does not convert the format of date.

Thanks in advance

Rodolfo Silva

--

Dave Peterson