Using VBA for Onclick Events 1

[AZGuy82]

I have been trying to resolve this for quite some time so I thought perhaps somebody on this good board might be able to help.

I am attempting to use VBA to open an IE browser, navigate to a website, and copy everything after clicking through a link.
The VBA code I have does just that, and loads the page properly.

On the source code for the page is the following link:

<li><a href="#" id="ma99" name="ma99" onclick="gS(1020,16);return false;">Prices</a></li>

I'm still learning and have not found out if there is code that could simulate a click of this link so that the Prices page loads and I can copy it.
I have tried:

    Dim FindCode
    FindCode = IE.Document.getElementsByID("ma99")
    FindCode.Click

and

    Dim inputElement
    For Each inputElement In FindCode
    If FindCode.getAttribute("id") = "ma99" Then
    inputElement.Click
    Exit For
    End If

amongst several other options, and am still unable to get this to work. Any chance somebody can help point me in the right direction?

 

[Gruuuu]

That second loop should have been

    Dim inputElement as IHTMLElement
    For Each inputElement In IE.Document.all
        If inputElement.getAttribute("id") = "ma99" Then
            inputElement.Click
            Exit For
        End If
    Next inputElement

Though I usually stick to the .innerText property (because I hate hunting through html for IDs)

    Dim inputElement as IHTMLElement
    For Each inputElement In IE.Document.all
        If inputElement.innerHtml = "Prices" Then
            inputElement.Click
            Exit For
        End If
    Next inputElement

 

[AZGuy82]

That works, thank you again Gruuuu you are amazing!