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