VBA to open .CSV file and format Columns A and C as text

[maacmaac]

I have the code to open a .CSV file but when the file opens, it is converting some of the data, not all, to a date. As example, one of the cell values in column A is '5MAR'. When the file is opened, it is being converted to 03/05/2012. I need to leave this cell as '5MAR'. In other words I need to keep both columns in a text format. I did try to convert the columns to text after the file was open but it only proceeded to convert those cells to number. Any assistance appreciated. Thanks

Please Login or Register  to view this content.

[maacmaac]

I tried to add the FieldInfo information but getting a 'Compile error' which indicates the 'Named argument not found' (FieldInfo)

Please Login or Register  to view this content.

[maacmaac]

Bump no response