Dear all, i have a text file containing the following sample data. I would like to convert some of the data into excel file. Basically i just want the field name and the value to be converted into the excel. Can someone help me on how to convert it into excel using excel macro?
Sample text file content:
START-OF-FILE
REFNUMBER=12345
DATEFORMAT=yyyymmdd<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
START-OF-FIELDS
FIELD1
<o
>FIELD2
FIELD3
FIELD4
.
.
.
FIELD120
END-OF-FIELDS
START-OF-DATA<o
></o
>
<o
>VALUE1</o
>
<o
>VALUE2</o
>
<o
>VALUE3</o
>
<o
>VALUE4</o
>
<o
>.</o
>
<o
>.</o
>
<o
>.</o
>
<o
>VALUE120</o
>
<o
>END-OF-DATA
END-OF-FILE
Preferred excel format:
FIELD1 FIELD2 FIELD3 FIELD4 . . . . FIELD120
<o
>VALUE1 VALUE2 VALUE3 VALUE4 . . . . VALUE120
</o
></o
></o
>
Sample text file content:
START-OF-FILE
REFNUMBER=12345
DATEFORMAT=yyyymmdd<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




START-OF-FIELDS
FIELD1
<o

FIELD3
FIELD4
.
.
.
FIELD120
END-OF-FIELDS
START-OF-DATA<o


<o


<o


<o


<o


<o


<o


<o


<o


<o

END-OF-FILE
Preferred excel format:
FIELD1 FIELD2 FIELD3 FIELD4 . . . . FIELD120
<o

</o


