Import Text file Fields as Columns in Excel

Hi all,

I have a text file that contains more than 1 lakh lines.
the text file contains 2 fields, the field length of the 1st field is 22 chars.
I wanted to import that text file into excel spreadsheet.
Since the lines in text file is more than 1 lakh, I got help on this forum from RoyUK, to split the text file and write into 2 spreadsheet.
Code:

Please Login or Register  to view this content.

What current code does:
It reads lines and writes into excel spreadsheet in a active sheet and read line by line.
What I want:
I want some changes in the above code that will read the line as 2 fields and write the value of 1st field(22 chars) in column A and the 2nd field in Column B.
I want the writing/importing to be done from the first cell of the excelsheet and not from any active sheet.

Hoping for a solution.
Thanks in advance.

I have modified my text file with comma delimited file and the following code gives me what I want, but with one issue.
The comma is also written in the first column.
I dont want the comma to be written.
Is there any way to do so.
Have attached the workbook with the macro and the text file for testing.
code:

Please Login or Register  to view this content.

Thanks in advance.