Hi,
I am a learner who is automating some data from reports to ease my month end pressures. The code below is used to open a text file (a report from our ERP) and seperate the text into columns. Two of the arrays return dates. However, the dates get returned in both US and UK formats. Is there a way to apply formatting at this stage? Formatting later is too late as the date format is already corrupted.
Workbooks.OpenText Filename:=myFilename, _
Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:= _
Array(Array(0, 1), Array(4, 1), Array(14, 1), Array(25, 1), _
Array(51, 1), Array(60, 1), Array(72, 1), Array(77, 1), Array(98, 1), _
Array(119, 1), Array(125, 1), Array(133, 1), Array(144, 1), Array(159, 1), Array(174, 1))
I am working on sperating the days, months and years seperately and then rejoing later in the program. However, I want to continue to improve my knowledge of VB.
Thanks for any help offered.
Mike