Click on particular name in webpage using VBA in excel

**bhavsarankit05** · 04-08-2014, 02:26 AM

Hi everyone,

I want to write a macro with which i can click on a particular hyperlink in that website.

For example...the website is "http://data.worldbank.org/country"...In this websote I want to click on the particular country (Let say "Gabon")...but I want to click it by using vba from excel.

I hope you guyz are expert and can help me out on this problem.

Thanks,
Ankit.

**pike** · 04-08-2014, 04:58 AM

one way

create a userform and add a combo box and command button , Reference Library "Microsoft HTML Object Library"
copy and paste the code below into the userform

Please Login or Register  to view this content.

**bhavsarankit05** · 04-16-2014, 08:32 AM

Thanks Pike... It is working fine..
You have an amazing knowledge about how code works. I will really appretiate if you could add comment to your code (wherever required) therefore it may be easy to understand for me ?

Thanks again,
Ankit.

**pike** · 04-17-2014, 12:07 AM

Hi bhavsarankit05
Sure ... hmmm....Basically

The UserForm_Initialize uses the XMLHTTP object to retrieve the result of the query, instead of instantiating Internet Explorer it uses the MSXML Object Model. Using the the HTML Object Model the result is HTML, not XML. It saves the url page in the HTMLDocument Object. After manually looking at the markup code (source code) to find specfic HTML ID. It uses the getElementByid Method return a specfic HTML ID and the getElementsByTagName Method to return a collection of all the elements with the given tag name in the ID. It then loops through the resulting collection and puts them into a array to use in the combobox.
The combobox/comandbox use Internet Explorer to navigate to the site.