Select HTML item using VBA Excel

Question

I tried to extract somes information from ALibaba.com but i didn't success to select Supplier in the list

Here is the html code

 Set Post = IEdoc_ALi.getElementsByClassName("ui-searchbar-type-option").Item
 Post.all(2).innerText = "Suppliers"

Thanks in advance

QHarr · Accepted Answer · 2019-11-24 17:19:41Z

1

It's a link that needs clicking. You can use a css attribute = value selector to target the relevant node and then apply the click method.

Option Explicit   

Public Sub SelectSuppliers()   
    Dim ie As SHDocVw.InternetExplorer

    Set ie = New SHDocVw.InternetExplorer

    With ie
        .Visible = True
        .Navigate2 "https://www.alibaba.com/"
        While .Busy Or .readyState <> 4: DoEvents: Wend
        .document.querySelector("[data-value=suppliers]").Click

        Stop '<Delete me later
    End With
End Sub

edited Nov 24, 2019 at 17:19

answered Nov 24, 2019 at 17:14

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

alowflyingpig Over a year ago

Accepted. As this is going to help me do something I was planning (with a different wbsite that is)

Collectives™ on Stack Overflow

Select HTML item using VBA Excel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related