Trying To Click A link in Web Page using excel vba code

ranjith1984 · Feb 22nd 2018

Hi Experts,

I am new for VBA and this FORUM, actually i am trying to click a link called "Multiple Product Query" in webpage which i used in my office.

I tried in many ways but i was not able to achieve hence seeking your help.

Hope someone will assist me to complete the coding. (HTML Code copied in below vba coding)

Code

Sub test()




Dim ie As Object
Set ie = CreateObject("InternetExplorer.application")
With ie
    .Visible = True
    .Navigate ("myurl")
    While .busy Or .ReadyState <> 4: DoEvents: Wend
End With


------------ <span class="urTxtStd">Multiple Product Query</span></nobr></a><span class="urTxtStd">Multiple Product Query</span> --------


End sub

Display More

Thanks,
Ranjith

Trying To Click A link in Web Page using excel vba code

Participate now!

Share