Hi,

I am working on a code which will process a text file (TempFile.txt),
which contains a data copied from an Outlook .msg file containing a
table (single table-2 Columns data). The text file contains text
extracted from various MS Outlook .msg files & copied to a
TempFile.txt.

The data in generated textfile looks like :

Agent's Name
Thomas Rody

Gender
Male

etc....

What i want to do is to transpose the data under the same labels used
as Column Headers in an Excel sheet.


Code will look something like....

Sub ProcessTempFile(TempFileName as String, Datasheet as Worksheet)
....

I donot know how to extract data from a text file & tranpose
horizontally under each header column e.g.

Column A Column B Column C Column D
---------------------------------------------------
Agent's Name Thomas Rody Gender Male

Please Help!