由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Programming版 - help- date is incorrectly converted when read csv using vba in excel
相关主题
请问const myClass &src 和myClass const &src有什么区别?Redis和Memcached有什么区别?
a question about const referenceWeb Service的Basic Anthentication是怎么一回事?
一个partial specialization的问题self defined data type problem
C++ Template Questionhow to do it ?????
C++ Q06: POD versus Aggregate-type如何测量最大内存消耗?
用c怎么实现generic stack (转载)如何用tornado web server写可以处理curl命令的程序
大牛给讲讲monad吧?$100求个小软件:下载我paypal上全部的transaction
祝大家周末愉快--请教个jquery/js/ajax的问题。perl webcrawler needed to download google trend data
相关话题的讨论汇总
话题: excel话题: jan话题: csv话题: vba话题: converted
进入Programming版参与讨论
1 (共1页)
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!
1 (共1页)
进入Programming版参与讨论
相关主题
perl webcrawler needed to download google trend dataC++ Q06: POD versus Aggregate-type
问个matlab 数据读入的问题用c怎么实现generic stack (转载)
问一个python问题大牛给讲讲monad吧?
一个搞统计的对C#的第一印象祝大家周末愉快--请教个jquery/js/ajax的问题。
请问const myClass &src 和myClass const &src有什么区别?Redis和Memcached有什么区别?
a question about const referenceWeb Service的Basic Anthentication是怎么一回事?
一个partial specialization的问题self defined data type problem
C++ Template Questionhow to do it ?????
相关话题的讨论汇总
话题: excel话题: jan话题: csv话题: vba话题: converted