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:

Constant    Value    Description
vbNormal       0      (Default) Specifies files with no attributes.
vbReadOnly     1      Specifies read-only files in addition to files with no attributes.
vbHidden       2      Specifies hidden files in addition to files with no attributes.
VbSystem       4      Specifies system files in addition to files with no attributes. Not available on the Macintosh.
vbVolume       8      Specifies volume label; if any other attributed is specified, vbVolume is ignored. Not available on the Macintosh.
vbDirectory   16      Specifies directories or folders in addition to files with no attributes.
vbAlias       64      Specified file name is an alias.

**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.

   WorkBooks.Open "C:\Program Files\Some.htm"

**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