VBA code to get values inside HTML

1

I want to collect two values from an HTML through VBA. The information '40 New 'and the' $ 19.95 '. My code succeeds in getting '$ 19.95', but in the following iteration it overwrites and gets '$ 17.38'.

'SetQuestionList=html.getElementById("olp_feature_div")
Set Questions = QuestionList.Children

For Each Question In Questions

If Question.className = "a-section a-spacing-small a-spacing-top-small" Then

Set QuestionFields = Question.all
For Each QuestionField In QuestionFields

If QuestionField.className = "a-color-price" Then

votes = Replace(QuestionField.innerText, "votes", "")
votes = Replace(votes, "vote", "")
Cells(RowNumber, 2).Value = Trim(votes)
End If
    
asked by anonymous 03.12.2014 / 22:47

0 answers