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.
Can anyone help me with extracting
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