Thread: Date problem when opening a csv with dates in dd-mm-yyyy format.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeroen Hofs[_2_] Jeroen Hofs[_2_] is offline
external usenet poster
  
Posts: 4
Default Date problem when opening a csv with dates in dd-mm-yyyy format.
When I open a csv with a date in one "cell" excel allways interprets the date
as mm/dd/yyyy if I do it in VBA, but if I open the CSV manually then excel
interprets the date according to my system date settings. How can I tell
excel how to interpret the date within VBA when opening a CSV?

Reply With QuoteReply With Quote