How to convert text file into excel using macro vba

I

ixara

Dear all, i have a text file containing the following sample data.
would like to convert some of the data into excel file. Basically i jus
want the field name and the value to be converted into the excel. Ca
someone help me on how to convert it into excel using excel macro?

Sample text file content:
------------------------

START-OF-FILE
REFNUMBER=12345
DATEFORMAT=yyyymmdd

START-OF-FIELDS
FIELD1
FIELD2
FIELD3
FIELD4
 
M

merjet

What is the "field name"? What is the "value"? Those don't appear as
such in your sample text file.
 
Top