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