Reading data line from multiple txt files

I have a folder containing 10 txt files. I would like to:

access all 10 files
loop through data lines of each file until a line starting with "Apples"
write the entire "Apples" line in an Excel sheet

Seems easy - unable to google an answer yet though - anyone more clever than me?
Thank a lot / Doc

I do something similar in parsing GPS files. I read each line of each file in the folder and insert only the lines starting with $GPGGA. Here is my code (abbreviated). Hope it helps

Please Login or Register  to view this content.

I have not included the Browse function here, something I found somewhere, and you would have to start the rindex (row to write to) and change to "Apples" and your worksheet tab name.

By the way, this reads every file in the selected folder regardless of type or content. The Browse function is

Please Login or Register  to view this content.

Hi Johnny

The folder is fixed so I don't need a prompt.

When I run the modified code it will read from the first file, but then I get an error that the file is already open...? Any input on how to close the file before checking the next?

Thanks/Doc

Originally Posted by Dr. Schwartz

loop through data lines of each file until a line starting with "Apples"
write the entire "Apples" line in an Excel sheet

Try

Please Login or Register  to view this content.

Sorry. As I edited out my code I inadvertently left out the Close #1. You need that statement before you loop back to the next file.

For after your path is set

Please Login or Register  to view this content.