Tags Tags

How to convert text file into excel using macro vba

February 08th, 2012 - 03:33 am ET by ixara | Report spam
Help Create a new topic
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
REFNUMBER345
DATEFORMAT=yyyymmdd

START-OF-FIELDS
FIELD1
FIELD2
FIELD3
FIELD4
email Follow the discussionReplies 2 repliesReplies Make a reply

Similar topics

Replies

#1 merjet
February 08th, 2012 - 10:50 am ET | Report spam
What is the "field name"? What is the "value"? Those don't appear as
such in your sample text file.
Replies Reply to this message
#2 Tim Williams
February 08th, 2012 - 12:09 pm ET | Report spam
Is that the literal content ? Where are the field values ?


Sample text file content:


START-OF-FILE
REFNUMBER345
DATEFORMAT=yyyymmdd

START-OF-FIELDS
FIELD1
FIELD2
FIELD3
FIELD4
email Follow the discussion Replies Reply to this message
Help Create a new topicReplies Make a reply
Search Make your own search