Help in scraping data from website

Hello,

I am trying to scrape data from a public website with VBA. From Excel, I first load Internet Explorer to a specific website, enter my search value, choose the proper bullet button and click on the search button. All this is working fine.

My problem is that I was not successful in finding the proper hyperlink name in the source code of the webpage and therefore I am unable to have VBA click on it to reach the final webpage I want where I would like to copy information to Excel.

The hyperlink I would like to click is the first search results that appears, in my example it is named: Various Clerical positions, Winnipeg Tax Centre, Winnipeg, MB (Open to the General Public) (Amended)

I am including the VBA code below. The code is working and is currently clicking on the Contact us hyperlink but this is not the hyperlink that I would like to click on. FYI, I added as references (Tools menu, then references…) the Microsoft HTML Object Library + Microsoft Internet Controls.

Thank you in advance for your time.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you ABB33 and Chippy. Both solution worked but I ended up using ABB33 solution because when there was 2 results, ABB33 solution click on the first one as Chippy clicked on the 2nd. Thanks again for your time, will mark as solved.