VBA Code to click a button on a VBA page

[Mike UK]

Hi.
I am trying to use my VBA code to click a button on an IE Web page. I have tried various lines of code but keep getting the Object Error 424.

Below is the web page code detailing the button....

<td id="cellInvestment </br>Choice" align="left" name="cellInvestment </br>Choice" class="wizardNavSelected"

                     onclick = "return wizard_move('/Admin/ModelPortfolios/InvestmentChoice.aspx','');"

                    style="CURSOR: pointer;">

                    <span class="roundSelected"></span>

                    <span class = "WizardNavNumber">2. </span>Investment </br>Choice

                </td>

The VBA code I have tried includes:

    Set btn = ie.document.getElementById("cellInvestment")
    btn.Click

ie.document.querySelector("button[type=submit]").click

The macro code looks like:
Sub Macro3()
Dim a As String
    Set App = CreateObject("InternetExplorer.Application")
    'Creates IE Webpage
    With App
        .Visible = True
        .Navigate "[URL]https://HIDDEN[/URL]"
        Do Until .ReadyState = 4
            DoEvents
        Loop
    End With
   
    Set btn = ie.document.getElementById("cellInvestment")
    btn.Click

Any help greatfully received.

 

[Worf]

Were you able to solve this one?

 

[Mike UK]

Were you able to solve this one?

Hi Worf,
Yes thank you.... I used this....

Set app = CreateObject("InternetExplorer.Application")

                    With app
                        .Visible = True
                        .document.getElementById("cellInvestment </br>Choice").Click
                    End With

             Application.CutCopyMode = False                                            'Clears the Clipboard ready to copy the webpage
             Application.Wait (Now + TimeValue(DelaySec))

Though I had to put a timed loop in post the click to allow the table to load post clicking the button as the ReadyState = 4 didn't seem to work.

Thank you for taking the time to check.