y***i 发帖数: 34 | 1 anyone had this problem before?
I tried to read "," delimited CSV file in EXCEL 2007 using VBA, but
Workbooks.OpenText Filename:=curFilepath + "\Settlement.csv", DataType:=
xlDelimited, comma:=True
it converted "Jan-09" to Jan 09, 2008. Actually, it should be Jan-2009.
Microsoft said it is a problem in EXCEL 2002.users have to change register
file.
Any expert knows how to fix it in code, not in register file?
Thanks a lot! |
|