vba to search text file and return value

[ike69]

I have a folder of text files (C:\Users\Rick\Documents\pdftotxt\txt). I have been reading about vba code that can read through these text files and return valves into excel. So for example, can a code read through 10 text files searching for flash point and boiling point and return those valves into an excel sheet.

 

[Rijnsent]

Hi Ike,
yes, VBA can do that, but you'd have to code a bit. Starting points:
https://www.mrexcel.com/forum/excel-questions/792452-search-string-text-file.html and https://www.mrexcel.com/forum/excel-questions/68673-text-file-search-excel-vba.html
Cheers,
Koen