Reading From HTM Files

**modytrane** · 06-23-2009, 12:09 PM

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

**Leith Ross** · 06-23-2009, 05:49 PM

Hello modytrane,

I assume your talking about using the Dir to function to identify whether a string is a valid directory.

Syntax
Dir [(pathname[, attributes])]

The attributes argument settings are:

Please Login or Register  to view this content.

**modytrane** · 06-23-2009, 09:16 PM

Thanks Leith,
That's very helpful in understanding the DIR function.

Now the original question in my post.
I have a number of .HTM files [all in one directory].

I can open these files with Excel and they automatically open as .xls files.
I can access the data by referencing cells etc.

When I try to open them from within VBA, they open as webpages and I can't access data.

From VBA, can I force the system to use Excel to open them?

I have sort of figured out a workaround [not implemented yet].
I can use Name function to change the file extension from .HTM to .XLS and then open them from VBA. But I am not sure if this is the right way to approach the problem.

Thanks again for your help.
modytrane

**Leith Ross** · 06-23-2009, 10:32 PM

Hello modytrane,

To open the .htm file in Excel, use the Workbooks.Open method.

Please Login or Register  to view this content.

**modytrane** · 06-24-2009, 07:30 AM

Leith,
When I open the .HTM file with that command, it opens as a Web Page.
I want to open it as an excel file, so I can copy certain cells from it. Can I force Excel to open it. It works when I open it manually from the Excel program.
Thanks,
modytrane