Web scraping not pasting values in the order they appear on the page.

[sdoppke]

Hi - I use the below code to scrape two sets of date from a web page. However the data is not pasting in the order it shows on the screen (web page). Is there something I am missing in my code?

Thanks in advance for any help.

SD

f = 6
Set html = objIE.Document
Set elements = html.getElementsByClassName("nameLabel")
For Each element In elements
        Workbooks("RTM_Tool").Sheets("RTM").Cells(f, 12).Value = element.innerText
    f = f + 1
Next element

g = 6
Set html = objIE.Document
Set elements = html.getElementsByClassName("adherence")
For Each element In elements
        Workbooks("RTM_Tool").Sheets("RTM").Cells(g, 13).Value = element.innerText
    g = g + 1
Next element

 

[Worf]

Hi

• Can you share a link to the page? You may have something as the table beneath there.
• Try looping as shown below.

For i = 0 To elements.Length – 1
     [e9]. offset(i)=elements(i).innertext
next
‘untested

Element3​

Element4​

Element1​

Element2​