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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Macros to convert Data into date format and then plot in graph 7
Excel VBA macro to auto import new CSV file from fixed directory 1
convert unformated text from word to excel 1
How to create macro to change value in CSV. 0
Convert to Excel Macro 2
Convert to Excel Macro 3
Save records from one file into seperate other files. 6

Top