Porting data from text file to Excel worksheet with visual basic 6

i have a text file which contains some values, it is some kind of address information generated from unix system.

like:

Name : James
Address: Bond village 13 Dhup Sari Road
Tel : 5217869

and so on...

Text file contain hundrads of address... i need to format this file in Excel.... Need to port data of this file in Excel Using Visual Basic.

it is my study assignment and i have just a little touch with visual basic.

Plz help me out, give me some idea or code if u have....

Amir

i have a text file which contains some values, it is some kind of address information generated from unix system.

like:

Name : James
Address: Bond village 13 Dhup Sari Road
Tel : 5217869

and so on...

Text file contain hundrads of address... i need to format this file in Excel.... Need to port data of this file in Excel Using Visual Basic.

it is my study assignment and i have just a little touch with visual basic.

Plz help me out, give me some idea or code if u have....

Amir


first, you need to learn to open text files, then do some string manipulation (you may use Split() function) and save these strings to an array, then you can call excel application and populate it with the data on your array. :rolleyes: