Simple Web Scrape

TNTScrub

New Member
Joined
Jan 7, 2021
Messages
14
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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???

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

HTML:
<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.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

John_w

MrExcel MVP
Joined
Oct 15, 2007
Messages
6,818
Try this:
VBA Code:
Dim Table As Object
Set Table = ie.Document.getElementById("GridView_CyclesFound")
Range("B1").Value = Table.Rows(1).Cells(0).innerText
 
Solution

TNTScrub

New Member
Joined
Jan 7, 2021
Messages
14
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Try this:
VBA Code:
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,243
Messages
5,657,575
Members
418,401
Latest member
B_A_M155

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top