General discussion
July 21, 2003 at 12:28 AM
parli singh

Opening CSV File in Excel using VBA

by parli singh . Updated 23 years, 2 months ago

Is this an anomoly in Excel, If you open a CSV file in Excel (XP) using VB and there is a column of dates (dd/mm/yy) in the CSV file. when the file opens some of the dates change in the column change to (mm/dd/yy). Weird!
Is this a know anomoly?Is there a Cure?

(Workbooks.Open Filename:=fn) where fn = filename

This discussion is locked

All Comments