I am having a problem with dates in a file that is saved as CSV. I open the /csv through a macro in my Excel file. I found a reply on EE where someone was having a similar problem. I am posting this to see if there is an alternative solution to the one posted.
the problem is that any date from 1 -12 will change to American dates when the file is opened i.e. 1/7/2014 will change to 7/1/2014, 11/7/2014 will change to 7/11/2014 etc but 13/7/2014 will stay as 13/7/2014 etc
the solution posted was @ http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21635074.html
To make a temporary csv based on the original csv, but only all dates are in "mm/dd/yyyy"-format
Name CVSFIlename As CSVFilename & "z"
Open CSVFilename & "z" For Input As #1
Open CSVFilename For Output As #2
Do While Not EOF(1)
Line Input #1, rawdata
'correct date zone
dateloc = 12 'for example
mnth = Mid(rawdata, dateloc, 2)
Select Case mnth
newdate = "Jan"
moddata = Left(rawdata, dateloc) & newdate & Mid(rawdata, daleloc, 3)
Print #2, moddata
Kill CSVFilename & "z" 'delete the temp file
Is there am alternative to this. My dates are in Column H in my file.