Vb, How to pull exact information from header

Hello,

I have a few questions:

1. How do I extract information from DAT & CSV files without opening the file and copy to a excel 2007 workbook sheet1?

2. I will be copying Colums B to E THEN the information I need to FIND is in a Header Row (F1 to OM1). I will need to copy the entire column once it finds exact parameters. There are over 300 Header Row Parameters and I will only need to copy 4 parameters, for example 250_0300_VTM_(20/20), 250_0300_Idsat_(3.6/3.6)_(20/20), 250_0300_VTM_(20/0.35), 250_0300_Idsat_(3.6/3.6)_(20/0.35).

3. There are over 50-100 DAT files or CSV files and each file will have different header Parameter BUT the consistent naming should start after _VTM or _Idsat. The first part will change for example 250_0300 or 160_0250 or 270_0493 or 250_0310 so maybe this can be ignored during the match.

Thank you for any help

Weenie