Get specific info from web page

gordsky

Well-known Member
Joined
Jun 2, 2016
Messages
556
Office Version
  1. 2016
Platform
  1. Windows
Hi All hoping someone can assist with this one.

We have a web page at work that you can search for a member of staff and it will bring back a page with their info on it.
Part of the page will contain their managers details.

I already have a piece of code within a spreadsheet that will open the staff details page within Microsoft Edge and then I manually enter the managers details into my spreadsheet from the info on the page

I would like to take this a step further and automate the process so taht VBA will pull that piece of info from the page and insert it into a given cell within the spreadsheet.

I have found the relevant bit of code within the page but have no idea how to extract it to excel via VBA
I have changed the actual weblink & Managers Name to weblinkhere & SupvNameHere due to company protection rules in the code below.

SQL:
<div class="panel bg-brick-red managed-by">
        <h2 class="panel-title">Line manager</h2>
        <ul class="panel-list compress arrows">
            <li>
                <a href="weblinkhere">SupvNameHere</a>
            </li>
        </ul>
    </div>

Can anyone help me with extracting
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,223,886
Messages
6,175,195
Members
452,616
Latest member
intern444

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
Back
Top