Taking information from website

[JohnPeter]

Hey,

I need to grab the title of the first document from a search on 'https://infostore.saiglobal.com/en-au/Search/'

For example; 'https://infostore.saiglobal.com/en-au/Search/All/?searchTerm=as%201400/'

And paste it 2 cells to the right of the currently selected cell.

From where i've found the element i believe the line for this should be something like;

cell.Offset(, 2) = IE.document.getElementById("ctl00_ContentPlaceHolder2_MainContent_uxColumnDisplay_ctl00_uxControlColumn_ctl00_uxWidgetHost_uxUpdatePanel").getElementsByClass("product-item--body span10").getElementByTagName("a").innerText

As the cell.offset(, 2) = is pasting to the right, and everything preceding the equals sign is calling the ID, the class, and the tag.

Where have I gone wrong?

Thanks.

 

[JohnPeter]

Not sure how to edit, but from that search i would require 'AS/NZS 1400:1997'