Hello,

Hopefully, someone is able to help me with this problem I have. I have roughly 1,000 .htm files in one folder. I would like to select certain information from these files, which have the same position in each file, and have that information imported automatically on one excel file, which would have 1,000 rows and 7 columns. I figured there would be a macro for this, but I am unable to find it. I am currently using Excel 2010. If you need any additional information, please let me know.