VBA-IE: Click on HTML element with only a href attribute

Asked Jan 03 '18 at 18:38

Active Jan 03 '18 at 18:38

Viewed 747 times

I need to go to the next page by clicking "Anmelden". enter image description here

This elements are described in html code as:

<nav id="main-menu" role="navigation">

          <a href="https://csp.stocko-contact.com/portal/">Startseite</a>
          <a href="https://csp.stocko-contact.com/portal/authenticate.php">Anmelden</a>  </nav>

In my VBA code I try to pick this links with code:

Option Explicit
Dim IE As InternetExplorer
Dim l As Object
Dim link As HTMLAnchorElement

(...)

For Each l In IE.Document.getElementsByTagName("a")
    If l.href = "https://csp.stocko-contact.com/portal/authenticate.php" Then
    l.Click
    End If
Exit For
Next

I work with IE8. Any advice? Thanks in advance.

edited Jul 09 '18 at 19:34

Community

asked Jan 03 '18 at 18:38

Małgorzata Rewekant

If you're searching the href for a *specific* URL, why not just `IE.Navigate "https://csp.stocko-contact.com/portal/authenticate.php"`? – dwirony Jan 03 '18 at 18:43
Why not, instead of `l.Click`, put in `IE.navigate l.href`? – Jeremy Jan 03 '18 at 18:46
Your `Exit For` should be inside the `If` block after `l.Click`: as it stands your loop will always exit after the first link is checked. – Tim Williams Jan 04 '18 at 00:57
You were right, IE.Navigate was the simplest solution. Thank you for your comment. – Małgorzata Rewekant Jan 08 '18 at 18:00

VBA-IE: Click on HTML element with only a href attribute

0 Answers0