If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Mapping HTML trees with VBA

Thread starter Worf
Start date Jul 13, 2022

Overview Reviews (1) Discussion

Worf

Well-known Member

Jul 13, 2022

Worf submitted a new Excel article:

Mapping HTML trees with VBA - This article shows how to list parents and children that form the structure of Web pages.

When performing Web scraping, sometimes it is necessary to analyse how the page was constructed. Here are the main features of this post:

Lists the XPath for all pairs of parent and child for a local HTML test file.

Informs how many levels the page has and the tag for each element.

When tested with an actual Web page(www.mrexcel.com), it totalized 339 elements arranged on 12 levels.

View attachment 69228...