|
Subject:
|
Excel text Import and VB
|
|
Posted By:
|
Franck
|
Post Date:
|
1/8/2004 8:57:15 AM
|
hi guys,
I've read the International Issues Part II document about that subject (and that's how i discovered the forum), but the advices provided are still not working for my case.
I'm trying to import a csv file using a VB macro. The code i use is very basic. My date are in european format (dd/mm/yy).
But even if my regional settings are setup like this, and my code says:
Workbooks.OpenText toto, xlWindows, , xlDelimited, , , False, True , , , , , _
Array(Array(1, 4), Array(14, 4), Array(17, 4), _
Array(19, 4), Array(21, 4), Array(23, 4), _
Array(25, 4), Array(27, 4), Array(29, 4), _
Array(31, 4))
I still have some dates that are imported the wrong way (for example, a 1st september 2003 (01/09/2003) is considered as a 9th Jan 2003)...
Does any of you have an idea on how i could manage that?
Thank you very much for your help.
Franck
|
|
