Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format is not correct when using OpenText in Excel 2000
Using Workbook.OpenText will chage dateformat dd/mm/yyyy =
mm/dd/yyyy. Workbooks.OpenText Filename:="C:\Test1.csv", DataType:=xlDelimited, _ TextQualifier:=xlTextQualifierNone, FieldInfo:=Array(1, 4) This have been fixed in a hotfix for excel 2002 http://support.microsoft.com/default.aspx?kbid=835718 Is there any hotfix for excel 2000 or work around? Thanks in advance // Mats |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format is not correct when using OpenText in Excel 2000
A common workaround is to rename the text file to .TXT. Then you can specify
the type of date you want (dmy). I like to record a macro when I do it manually to get the fields correct. Mats L wrote: Using Workbook.OpenText will chage dateformat dd/mm/yyyy = mm/dd/yyyy. Workbooks.OpenText Filename:="C:\Test1.csv", DataType:=xlDelimited, _ TextQualifier:=xlTextQualifierNone, FieldInfo:=Array(1, 4) This have been fixed in a hotfix for excel 2002 http://support.microsoft.com/default.aspx?kbid=835718 Is there any hotfix for excel 2000 or work around? Thanks in advance // Mats -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My Excel 2000 changes the format of my numbers, how do I correct? | Excel Discussion (Misc queries) | |||
How do I get the date correct in excel 2000 on a chart? | Charts and Charting in Excel | |||
Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
After OpenText all pastes from external apps use format from OpenText | Excel Programming |