Reading From HTM Files

I am in the process of creating a program that has to read a number of .HTM files.
These files can be opened with Excel. I need to open all files within same directory [approx. 370 files]. Read a few cells from each file and create a summary sheet in Excel.
I don't see any examples for this file type here.

I also have a question: In some of the codes I have seen here and used them successfully, I see a variable/attribute "vbDirectory". What is it and does it represent the file type?

I am just getting started, so any help or guidance will be very helpful.

Thanks,
modytrane