Macro to convert the text in to string.

I have a text file with lines. All I want to do is convert line text into number. I want to declare them as array.and output them in different cells in worksheet.
Example:
if one of the text line is-

Text input:
C390007797109040100000530000000031000040000000016

Excel output:
A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 M1 N1 O1
C 39 000779 7 1 09 04 01 00 00053 00000 00031 00004 00000 00016
(1, 2, 6, 1, 1, 2, 2, 2, 2, 5, 5, 5, 5, 5, 5) -> Length on the numbers
the text file has several lines. So there should be a loop to go through the end of file.
Please help me.

how can i do that? text into column will be okay for me.

No. I need array of these data for later use. so I cannot use the fixed width option. can you help me with that?

I have a C++ code for this problem. here is the code:

Please Login or Register  to view this content.

Please anyone help me to convert it into a macro.
Thank you.