vba scrape html - get element with dynamic class

Question

using excel vba i need to scrape the date (2019-01-16). this code works great:

Set wyjatek = ie.Document.getElementsByClassName("redesignTravelHistory tank-thlist__date 2019-01-16")(0)

but the problem is, that in every html I try to scrape, this date can be different. Do you know how to solve it?

part of html:

<div class="redesignTravelHistory tank-thlist__date 2019-01-16">16/01/2019</div>

1. use getElementsByTagName("div") to get a collection of all divs. 2. Loop throught that collection and use className property to read the class name. 3. Use string functions or LIKE to match a pattern in the class name. — cyboashu
– cyboashu, Commented Jan 23, 2019 at 20:51

QHarr · Accepted Answer · 2019-01-23 22:17:37Z

2

You can use a css attribute = value selector with ^ operator (value starts with substring after the =)

ie.document.querySelector("div[class^='redesignTravelHistory tank-thlist__date']")

If there can be more than one element matched with this then use querySelectorAll and index in to the nodeList to get the right element e.g. index 1

ie.document.querySelectorAll("div[class^='redesignTravelHistory tank-thlist__date']").item(1)

answered Jan 23, 2019 at 22:17

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TinMan · Accepted Answer · 2019-01-23 21:04:04Z

1

You are using the first element that contains 3 classes

I'm guessing that the date class "2019-01-16" is irrelevant and can be removed.

 Set wyjatek = ie.Document.getElementsByClassName("redesignTravelHistory tank-thlist__date")(0)

answered Jan 23, 2019 at 21:04

TinMan

7,8142 gold badges13 silver badges24 bronze badges

Heck...I didn't realize that you could query multiple class name till I read your post. Thanks for accepting my answer.