VBA code to click a link in a webpage (Two link with the same name)

ssuresh711

New Member
Joined
Feb 6, 2019
Messages
11
Hello Experts,

Requesting your support. I have been trying this code for more than a week.
I have a webpage when I navigate, I need to click a link "Transcript". The problem is the webpage having two transcript link. But I use the 2nd one.
I tried using SendKeys "{TAB}". Sometime only it is working. Mostly the webpage navigate to different page. Please advise the code to click the below highlighted link
 
Last edited by a moderator:

Some videos you may like

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.

ssuresh711

New Member
Joined
Feb 6, 2019
Messages
11
This is the HTML code:

<div id="content">
<h2 class="main">Douglas Hunt</h2>
<div class="tabtree">
<u1 class="tabrow0">
<li class="first one rwo here selected">...</li>
<li>...</li>
<li>...</li>
<li>...</li>
<li>...</li>
<li>...</li>
<li>...</li>
<li>
<a title="Transcript" href="https://examplelink.com">
<span>Transcript</Span>
</a>
</li>
 

Watch MrExcel Video

Forum statistics

Threads
1,109,544
Messages
5,529,457
Members
409,879
Latest member
Aussie_Excel_Wanna_Be
Top