View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Workbooks.Open incorrectly formating date column

CSV file format and Excel are notorious
if your regional settings are anything but USenglish :(


Step 1 .. RENAME the thing to TXT.


DO you have Excel XP or 2003?

Check out the LOCAL argument in
OpenText and
SaveAS methods

(again: ONLY for excel XP / 2003)
it appears to have been added as an afterthought..
and is hardly documented in VBA help.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"?B?UGF1bA==?=" wrote:

Hi,
I have a CSV file and one of the columns is date in the format of
DD/MM/YYYY. If I open this manually the date column is fine. If
however I open the same file in code...
Workbooks.Open Filename:="Log.csv"
Excel converts the dates where the first number is less than 13 to an
american type date. I.e. 03/10/2004 becomes 10/03/2004.

How can I stop this from happening???
Ta
Paul