Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening a .csv file via VB
This is probably specific to Non-American versions but ... When I open a csv file via excel I get the expected format: MATR PROD_MONTH TIS 1 01/04/2002 3 1 01/04/2002 6 1 01/04/2002 9 The date formt is as written in the file dd/mm/yyyy in the abov example this is the 1st of april. When I open the file using Workbooks.Open Filename:="C:\test.csv" I get: MATRIX PROD_MONTH TIS 1 04/01/2002 3 1 04/01/2002 6 1 04/01/2002 9 The date is reversed internally to USA type mm/dd/yyyy - but because m regional settings are UK, excel interprets this as 4th January. Any ideas -- jmoffa ----------------------------------------------------------------------- jmoffat's Profile: http://www.excelforum.com/member.php...nfo&userid=115 View this thread: http://www.excelforum.com/showthread.php?threadid=47581 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening a .csv file via VB
The answer is to include the option local=true in the .ope -- jmoffa ----------------------------------------------------------------------- jmoffat's Profile: http://www.excelforum.com/member.php...nfo&userid=115 View this thread: http://www.excelforum.com/showthread.php?threadid=47581 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a file in Excel starts application but dose not open file | Excel Discussion (Misc queries) | |||
File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Error:Invalid File format,while opening an Excel Template file | Excel Programming |