|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to use MSHTML?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> 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>
More VS2003 to VS2005 questions
Write to an XML file using data from an SQLserver table Master Page Template difference between imports-implements-inherits ListBox Problem firing a dts package's execution How To Show Partial Classes as a Hierarchy in Solution Explorer? new line in datagrid cell Passing a parameter Collection newbie script question |
|||||||||||||||||||||||