Hi,

How could I open or merge two text file in excel, I am
trying to create a macro that would join my two text in
excel. Something like this:

File1 Contains my header:
Name
Company Name
Address
City

File2 Contains my data:
Joe Peter,ABC Company, 123 1st Street, Unicity
John Does, MyCompany, 345 22nd Street, City
..
..
.. and soon.

I want to put Name on top of Joe Peter, Company Name on
top of ABC Company, and soos

How could I do this?

Thanks for your help.
Eric