Simple Web Scrape

[TNTScrub]

Hi guys, I've done a bit of interacting with IE but I have never even attempted to scrape so I'm a bit overwhelmed. For the sake of simplicity I've got a number in A1 then I run a macro that does some web magic and eventually takes me to a page based on that number. What I need to accomplish is to extract one result ( <td>16989<td> )from an HTML table and place it in B1. Can I do something like this???

   Table = ie.Document.getelementbyid("GridView_CyclesFound")
   IndexKey = ie.Document.getelementbytagname("td")
   
   [B1] = IndexKey

<table id="GridView_CyclesFound" style="width: 620px; color: rgb(51, 51, 51);" cellspacing="2" cellpadding="4">
    <tbody>
        <tr style="color: white; font-weight: bold; background-color: rgb(93, 123, 157);">
            <th scope="col">Index Key</th>
            <th scope="col">Tag#</th>
            <th scope="col">Current Tech</th>
            <th scope="col">Select New Tech</th>
        </tr>
        <tr style="color: rgb(51, 51, 51); background-color: rgb(247, 246, 243);">
            <td>16989</td>
            <td>9753</td>
            <td>E000000 - Unassigned</td>

Honestly I think this is probably beginner level easy but I just don't know enough about this to make it work. Please help.

 

[John_w]

Try this:

Dim Table As Object
Set Table = ie.Document.getElementById("GridView_CyclesFound")
Range("B1").Value = Table.Rows(1).Cells(0).innerText

 

[TNTScrub]

Try this:

Dim Table As Object
Set Table = ie.Document.getElementById("GridView_CyclesFound")
Range("B1").Value = Table.Rows(1).Cells(0).innerText

John, That is perfect. I didn't know you could navigate through an HTML table that way. Thank you so much.