| 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 |
| 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 | |||
Threaded Mode
