I've had a look thru old posts, i think this one has come up before
but no-one seems to have a simple answer; I was upgraded (?)
yesterday from office 97 to 2000, including excel and vb, now xl2000
and vb6. i have a simple macro which opens a .CSV file (which comes
from a unix box via ftp), and saves it as .XLS one column is dates.
under XL97 no problem. Under XL2000, if i do it manually
(openfile/saveas .csv) no problem. If i do it under a VB6 macro,
either old one, or new one recorded today from xl2000, then when the
csv is opened it shows dates reversed; eg using a text editor the
date from unix box in the .csv is 05/08 (yesterday). using manual
opening of .csv, it's 05/08, serial number is 37839 (if i reformat it
as a number). Using macro to open it, it shows 08/05 (which my
machine reads as 8th may), serial number is 37780.
is there a simple way to set the date format used in the vba
process to be NOT US-centric? obviously this needs to be able to be
done before the file is opened, as once it's opened the serial number
is changed. thanks kkk