Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.

Ok, so i'm working with the following HTML which I have loaded into EXCEL using the InternetExplorer class.

<table width="100%" cellpadding="0" cellspacing="0" border="0"class="bgColor">  
<tr>  
<td class="spacerCell"></td>  
</tr>  

<tr>  
<td class="spacerCell">&nbsp;</td>  
<td nowrap align="right" valign="top" colspan="25"><input type="button" name="doneButton" value="Done" onClick="handleDone();" /></td>  
<td class="spacerCell">&nbsp;</td>  
</tr>  
<tr>  
<td class="tinySpacerCell"></td>  
</tr>  
<tr>  
<td class="spacerCell">&nbsp;</td>  

<td colspan="25">  
<table width="100%" cellpadding="0" cellspacing="0" border="0" class="bgColor">  
<tr>  
<td class="bodymdbold">Store:</td>  
<td class="bodymd" nowrap>Bramingham Park (505)</td>  
etc etc...

So the first table is accessed as follows:

Set oBrowser = New InternetExplorer  
Set HTMLDoc = oBrowser.Document  
...  
Set ieTable = HTMLDoc.getElementsByTagName("TABLE")(3)  

But my question is: how do I access the NEXT table inside the TD tag. I've tried

("TABLE")(4) 

but that gets the next child of the document!

share|improve this question
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["        <li><a href=\"http://area51.stackexchange.com\" title=\"proposing new sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"http://careers.stackoverflow.com\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2014 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2014.3.13.1457\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Stack Overflow works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class=\"dno\"></div>\r\n    </nos"], "copyright__copyright__copyright": [" ieTable = HTMLDoc.getElementsByTagName(\"TABLE\")(3)  \n\nBut my question is: how do I access the NEXT table inside the TD tag. I've tried\n\n(\"TABLE\")(4) \n\nbut that gets the next child of the document!\n\nshare|improve this question\nadd comment\n\nKnow someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.\n\nYour Answer\n\n\u00a0\ndiscard\n\nBy posting your answer, you agree to the privacy policy and terms of service.\n\nBrowse other questions tagged or ask your own question."]}