Read whole file,Match the headers based on specific condition & write to text file

Dear VBA forumers and guides,

I need a small example to guide me to read my entire excel data and match certain columns, and output certain selected columns to a .txt file. Have a file of around 300 columns and 1000 rows. (Using 2007 Excel)

To be more clear,
Out of my Excel sheet I want only Drive Type Date ID TagName Description QTY DID values in my text file.

In my excel file I have a header field called DriveType and that data should be only CDD and if its anything else then reading of that row should be abandoned. (I mean the reading of other data shouldn't happen!!)

Secondly have a set of numbers(basically frequencies) in my header file and for every no in header have a corresponding value in rows. It can be blank or some numeric value. In case my numeric value is an n or n.5 (where n can be 1,2,3,...etc) then it should be written to the .txt file else not.

I also need to have a counter which keeps the count as to how many numeric values are found for each sale ID.(it is one of the header fileds which is important in my text file) and also need to remember the frequency where the value first occurred.

The second part of help I need is to go about formatted output. I need the fields in the text file output to have exactly 8 characters long. (I am clueless how to do this!!)

Brief example of my Excel data is attached.

Hope some one can help me!!
Thanks.

Quit whining about no-one helping & check if your question can be explained better

Hello macromaniac,

Do you need all the fields to be 8 characters or only certain columns? Your description and tag name fields exceed 8 characters. Do you want to truncate these to only 8 characters?

Alright, this may need to be worked on but it is a start.

Please Login or Register  to view this content.

I borrowed the fnum part from here and am not entirely sure how to declare fnum if Option Explicit is used.

I have also uploaded a copy of your workbook which uses a Button object for a quick run of the Macro.

Good Luck.

After playing with this a bit more, perhaps you want to append to the file instead. If so change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

I hope you realize your 'question' consists of 5 questions. So to me it seems to be more a project than a question.
What's your experience with VBA ?

Originally Posted by snb

I hope you realize your 'question' consists of 5 questions. So to me it seems to be more a project than a question.
What's your experience with VBA ?

Zero I would say

Dear all,

I once again personally thank Mordred for taking time out and for helping me out.
Its a great ton of support and encouragement I have recieved from this forum.
And sorry to all the people whom knowingly or unknowingly have irritated. Its just because of some mistake. Kindly forgive me and I greatly appreciate all the help I have received from the members here who depsite their busy schdules try to solve problems of people like me.

Mordred you are simply AWESOME!!

Thanks again,
Macromaniac

Originally Posted by royUK

Quit whining about no-one helping & check if your question can be explained better

loooooooooool !

He actually joined as a different ID - new2vb, to post negative rep & complain.