CSV Import, Macro currently overwriting columns

Hi,

I am attempting to import multiple .cor files into one workbook on separate sheets.
I have found got a macro which does this (see below) however I want to change it so that the macro separates both ":" and "tab" delimiters.
When I do this the data columns (starting at row 103) overwrite each other and I end up with one column of data instead of 4, but the text at the top is separated correctly.
I have uploaded my macro file and the data file (I cant upload .cor files so had to change it to an excel file.)

I have been trawling through forums but haven't been able to find a solution.

Thanks for your help

James

Please Login or Register  to view this content.

I have now managed to figure out how to do it, I modified the code as below.

Please Login or Register  to view this content.

Hi Richard,

Thanks for your reply and interest in helping me, I have managed to solve this issue now.

And changing the file to a .csv is an excellent idea I will do that next time.

James

data file as CSV.