Importing data from multiple text files into Excel VBA : <p>I might have a question about VBA and Excel Macros. The thing that I need to do is to import data (actually integer values) from multiple text files that have random generated names (for example 12345678.txt, 8654321.txt, etc.) but which are stored in the same folder (let's call it Data folder) to excel into a column. </p>

<p>The problem that I face is that I have the same name for the measured values (called MVA) that are repeating over and over in the text files. I don't need all the data from the text files, only some specific rows of these MVA (for the example below let's say that I need only the MVA number for the "LED 01 Intensity" which is 6250 to be stored in a new cell in Excel. And I need to get that value that comes after "LED 01 Intensity" in the MVA row from 10 multiple text files (with random names that I don't know) to be stored each one in separate cells in Excel (from A1 to A10).</p>

<p>Example_____________________________________________________________________</p>

<p>Name: 153588.txt</p>

<p>Date: 14.05.2016</p>

<p>Name of product: Electronic Device 01</p>

<p>CHECK TEST</p>

<p>Resistance 101</p>

<p>MVA: 2 Ohm</p>

<p>MAX: 5 Ohm</p>

<p>MIN: 0 Ohm</p>

<p>PASS</p>

<p>LED 01 Intensity</p>

<p>MVA: 6250</p>

<p>MAX: 10000</p>

<p>MIN: 5000</p>

<p>PASS</p>

<hr>

<p>I need a lot of these MVA values to be stored in Excel for analysis and I need to get an idea if this problem can be solved with VBA. If you can offer me some help to create a macro for this I would be thankful (I have basic knowledge of programming but I'm a beginner in VBA).</p>
