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 |
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 |
All times are GMT +1. The time now is 02:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com