none
GetElementsByTagName in Excel VBA

    Question

  • it seems to me a little tricky, hope someone will help me with this.

    i am looping thru a website where i have some order info, and i need to get out from there the shipping address into my excel sheet, but the problem is, the info is in a table with no tag name, it has a class name which i dont know how to deal with, maybe someone can give me some idea how to get the info from it, some coding? here is my page source.

    </div>
    
    
    
    
    
     
    
    
    
    
    
    
    
    <table class="data-display" cellspacing="1"><tbody>
      <tr class="list-row">
        <td class="data-display-field" width=30% valign="top"><strong>Shipping Address:</strong><br>John Smith<br>1234 Abcd Ave.<br>MACON,&nbsp;GA&nbsp;31207-1100<br></td>
        <td class="data-display-field" width=50% valign="top">
          <table class="data-display" cellspacing="0" cellpadding="0"><tbody>
            <tr class="list-row">
              <td class="data-display-field" width=40% style="font-weight: bold">Purchase Date:</td>
              <td class="data-display-field" width=60% >October 17, 2012 8:47:13 AM PDT</td>
            </tr>

    i need only this info,

    <td class="data-display-field" width=30% valign="top"><strong>Shipping Address:</strong><br>John Smith<br>1234 Abcd Ave.<br>MACON,&nbsp;GA&nbsp;31207-1100<br></td>

    for each break, should be in a new cell.

    how can i do that?

    Sunday, December 23, 2012 6:33 PM

Answers

All replies