New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Excel VBA Internet Explorer - syntax for DOM to get element

Macros, VBA, Excel Automation, etc.

Excel VBA Internet Explorer - syntax for DOM to get element

Postby TahorSuiJurisBenYAH » Sat Jan 16, 2016 4:28 pm

Hello, I am trying to get this value: <td align="center">28.67</td>

How would I structure this: .getElementsByTagName("table")

Any and all suggestions greatly appreciated.

Tahor


Code: Select all
'<table class="table table-striped table-bordered table-condensed" id="tblstats" cellpadding="0" cellspacing="0" width="80%">
'<thead><tr>
'    <th class="header" width="40%"><b>URL [Sort By URL]</b></th>
'    <th class="header" width="15%"><b>DA [Sort]</b></th>
'    <th class="header" width="15%"><b>PA [Sort]</b></th>
'    <th class="header" width="15%"><b>Moz Rank [Sort]</b></th>
'    <th class="header" width="15%"><b>Back Links [Sort]</b></th>
'</tr></thead>
'<tbody>
'        <tr class="rowclass1"><td><a href="http://moz.com/researchtools/ose/links?site=http://www.1fashionclothing.com/Default.asp" target="_blank">http://www.1fashionclothing.com/Default.asp</a></td><td align="center">28.67</td><td align="center">10.4</td><td align="center">0</td><td align="center">0</td></tr>
'</tbody>
'</table>
  • 0

TahorSuiJurisBenYAH
Rookie
 
Posts: 1
Joined: Jan 16, 2016
Reputation: 0
Excel Version: 2013

Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 111 guests