Return Website Inspect data

[mikeymay]

I am trying to scrape Find and update company information - GOV.UK to get the addresses of a number of businesses in the UK using the business company registration number.

Using VBA I can navigate to a businesses page
e.g.
The page for Barclays Bank is BARCLAYS BANK PLC overview - Find and update company information - GOV.UK

Within this page the businesses registered address is shown

With the inspection elements of

I have managed to find other elements I need but I can't seem to work out how to get the text that is the registered address.


TIA

 

[John_w]

You haven't said which library you're using (MSHTML or Selenium). This is Selenium:

    Dim dt As WebElement
    Dim dl As WebElement
    
    Set dt = driver.FindElementByXPath("//dt[text()='Registered office address']")
    Set dl = dt.FindElementByXPath("./..")
    Debug.Print Split(dl.Text, vbLf)(1)

 

[mikeymay]

You haven't said which library you're using (MSHTML or Selenium). This is Selenium:

    Dim dt As WebElement
    Dim dl As WebElement
   
    Set dt = driver.FindElementByXPath("//dt[text()='Registered office address']")
    Set dl = dt.FindElementByXPath("./..")
    Debug.Print Split(dl.Text, vbLf)(1)

I don't recognise the code you have provided so I am assuming I am using MSHTML.

 

[John_w]

For MSHTML, try one of these:

    Dim HTMLdoc As HTMLDocument
 
    Dim dl As HTMLDListElement
    Set dl = HTMLdoc.getElementsByTagName("dl")(0)
    Debug.Print dl.Children(1).innerText
 
    Dim dd As HTMLDDElement
    Set dd = HTMLdoc.getElementsByTagName("dd")(0)
    Debug.Print dd.innerText

I should clarify that the previous code was for Seleniumbasic. There's also SeleniumVBA which is actively maintained and updated. It also has the very useful feature of automatically downloading the driver library version to keep it synchronised with the current web browser version. For Seleniumbasic you have to download and install the latest web driver version (Microsoft Edge Web Driver or Chrome ChromeDriver) yourself to keep it compatible with the current web browser, which is typically downloaded and updated automatically.