Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to download data from a web site. I'm familiar with how to use
an InternetExplorer object to navigate to the page etc. But how do I get this data: The web page source for the table of data I want looks like this: <table border="0" cellpadding="15" cellspacing="0" width="580" <tr <td class="copy" <div class="mahead"<bItem 1</b -- <a href="http:// www.website.com/webpage.html"view page</a</div <div class="mahead"<bOther Thing</b -- <a href="http:// www.website.com/someotherpage.html"view page</a</div <div class="mahead"<bNew Stuff</b -- <a href="http:// www.website.com/yetanotherpage.html"view page</a</div <br /<br /<br /<br /<br / </td </tr </table Where my example shows only three items, the real web page has many more, each as a <div, all in the same <td. What I need to get is: [Field 1] [Field 2] Item1 http://www.website.com/webpage.html Other Thing http://www.website.com/someotherpage.html New Stuff http://www.website.com/yetanotherpage.html How do I get that data? BTW, if I use Excel's Get External Data From Web feature, I get this table: [Field 1] [Field 2] Item1 view page Other Thing view page New Stuff view page With no sign of the urls, which I need. Thanks for any suggestions. Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating customized hyperlinks to a site | Excel Discussion (Misc queries) | |||
Copy a table from a web site, then manipulate the data? | Excel Worksheet Functions | |||
How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!) | Excel Discussion (Misc queries) | |||
Import External Data Non-HTML Table | Excel Discussion (Misc queries) | |||
Getting Table data from HTML page | Excel Programming |