Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro changes the format of dates
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates format | Excel Worksheet Functions | |||
CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT | New Users to Excel | |||
Format text 'dates' to real dates | Excel Worksheet Functions | |||
Format dates | Excel Discussion (Misc queries) | |||
the dates on cell format make different dates. | New Users to Excel |