Home All Groups Group Topic Archive Search About
Author
20 Jun 2006 6:25 PM
Don
Does anyone know of any good examples of how to use MSHTML to open a
local html file and extract data from about 20 tables? Either VB.NET
2003 or Excel 2002.

Sorry, this is probably going to be messy but . . . here's an example
of one of the tables.

Your help will be appreciated.

    Don

<TBODY>
        <TR>
          <TD vAlign=center width=590 colSpan=2>
            <P><STRONG><FONT face="Arial, Helvetica" size=2><SPAN
            style="FONT-SIZE: 12px">Subject Property
            is</SPAN></FONT></STRONG><STRONG><FONT face="Arial,
Helvetica"
            color=#09573a size=2><SPAN style="FONT-SIZE: 12px">
            </SPAN></FONT></STRONG><STRONG><FONT face="Arial,
Helvetica"
            color=#457a7a size=2><SPAN style="FONT-SIZE: 12px">1152
            </SPAN></FONT></STRONG><STRONG><FONT face="Arial,
Helvetica"
            size=2><SPAN style="FONT-SIZE: 12px">Sqft
            with</SPAN></FONT></STRONG><STRONG><FONT face="Arial,
Helvetica"
            color=#457a7a size=2><SPAN style="FONT-SIZE: 12px"> 3
            </SPAN></FONT></STRONG><STRONG><FONT face="Arial,
Helvetica"
            size=2><SPAN style="FONT-SIZE: 12px">bedrooms,
            </SPAN></FONT></STRONG><STRONG><FONT face="Arial,
Helvetica"
            color=#457a7a size=2><SPAN style="FONT-SIZE: 12px">0.00
            </SPAN></FONT></STRONG><STRONG><FONT face="Arial,
Helvetica"
            size=2><SPAN style="FONT-SIZE: 12px">bathrooms
            <BR><BR></SPAN></FONT></STRONG></P></TD></TR>
        <TR>
          <TD vAlign=top width=250>
            <P>
            <TABLE borderColor=#808080 height=0 cellSpacing=0
cellPadding=0
            width=236 border=0>
              <TBODY>

Author
21 Jun 2006 5:41 AM
Cor Ligthert [MVP]
Don,

Maybe does this bring you on the route, you have to change it to read it
direct of course.

http://www.vb-tips.com/dbPages.aspx?ID=541adf13-d9c0-435c-893f-56dbb63fdf1c

I hope this helps,

Cor

Show quoteHide quote
"Don" <don81846@NO_CaCa.Earthlink.net> schreef in bericht
news:kueg92d60h022d2mlm17hgu34khicoado0@4ax.com...
>
> Does anyone know of any good examples of how to use MSHTML to open a
> local html file and extract data from about 20 tables? Either VB.NET
> 2003 or Excel 2002.
>
> Sorry, this is probably going to be messy but . . . here's an example
> of one of the tables.
>
> Your help will be appreciated.
>
> Don
>
> <TBODY>
>        <TR>
>          <TD vAlign=center width=590 colSpan=2>
>            <P><STRONG><FONT face="Arial, Helvetica" size=2><SPAN
>            style="FONT-SIZE: 12px">Subject Property
>            is</SPAN></FONT></STRONG><STRONG><FONT face="Arial,
> Helvetica"
>            color=#09573a size=2><SPAN style="FONT-SIZE: 12px">
>            </SPAN></FONT></STRONG><STRONG><FONT face="Arial,
> Helvetica"
>            color=#457a7a size=2><SPAN style="FONT-SIZE: 12px">1152
>            </SPAN></FONT></STRONG><STRONG><FONT face="Arial,
> Helvetica"
>            size=2><SPAN style="FONT-SIZE: 12px">Sqft
>            with</SPAN></FONT></STRONG><STRONG><FONT face="Arial,
> Helvetica"
>            color=#457a7a size=2><SPAN style="FONT-SIZE: 12px"> 3
>            </SPAN></FONT></STRONG><STRONG><FONT face="Arial,
> Helvetica"
>            size=2><SPAN style="FONT-SIZE: 12px">bedrooms,
>            </SPAN></FONT></STRONG><STRONG><FONT face="Arial,
> Helvetica"
>            color=#457a7a size=2><SPAN style="FONT-SIZE: 12px">0.00
>            </SPAN></FONT></STRONG><STRONG><FONT face="Arial,
> Helvetica"
>            size=2><SPAN style="FONT-SIZE: 12px">bathrooms
>            <BR><BR></SPAN></FONT></STRONG></P></TD></TR>
>        <TR>
>          <TD vAlign=top width=250>
>            <P>
>            <TABLE borderColor=#808080 height=0 cellSpacing=0
> cellPadding=0
>            width=236 border=0>
>              <TBODY>