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

[ranjith2523]

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)

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

'html code ------------ Multiple Product QueryMultiple Product Query --------

End sub
Thanks,
Ranjith

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...eb-page-using-excel-vba-code.html#post5015510

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.